help with report sort options

Want to post something that doesn't quite fit into the other forums? This is the place for that.
Post Reply
jdor
Posts: 51
Joined: Sun Aug 26, 2018 1:41 pm

help with report sort options

Post by jdor » Mon Sep 17, 2018 1:05 pm

Hi,

does anybody how or if its possible to modify "sort reports" by time

for example once you run a report and then select menu and criteria another sub menu appears from which you can select sort report
sort by
then by

now when you select the then by dropdown there is no option to select seen. so in the below screen shot

Image

it shows row 2 which is the second leg of the flight, first (manchester-singapore) first seen at 11:45, while the first leg (idaho-manchester) first seen at 08:45 is shown second

thanks for any advice/suggestions

agw
Posts: 2130
Joined: Fri Feb 17, 2012 3:20 am

Re: help with report sort options

Post by agw » Tue Sep 18, 2018 12:28 am

I'm not sure what you sorted by first but if you then sort by date it should sort by date/time. The date/time in question will be the point in time that the aircraft was first seen. I think.

jdor
Posts: 51
Joined: Sun Aug 26, 2018 1:41 pm

Re: help with report sort options

Post by jdor » Tue Sep 18, 2018 9:50 pm

I just sorted by date only. i did get it show in time order by selecting ascending but this shows the oldest date first eg

Monday 15 May 2017
09:20
11:37

Wednesday 17 May 2017
09:37
11:49

This correctly shows the inbound leg first (idaho-manchester) and the outbound leg (manchester-singapore) second which will have to do. unfortunately after trying several permutations of

sort by
then by

I could not get it to show the most recent flights first and in time order eg

Tuesday 18 September 2018
09:13 (1st leg idaho - manchester)
11:26 (2nd leg manchester - singapore)

Monday 17 September 2018

09:15 (1st leg idaho - manchester)
11:36 (2nd leg manchester - singapore)

Thanks for taking a look anyways

agw
Posts: 2130
Joined: Fri Feb 17, 2012 3:20 am

Re: help with report sort options

Post by agw » Fri Sep 21, 2018 11:40 pm

I think if you sort by date **and then by date** it should work. I.E. set both sort fields to Date.

Post Reply