Subreport Sorting (1 Viewer)

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 10:15
Joined
Sep 12, 2006
Messages
15,613
I am sure this has been covered before -
anyway, a client 's database prepares invoices by printing the invoice detail on a subreport, linked by invoice number.

Now, they want the lines on the subreport to be in date order, but try as I might, I can't get the subreport to sort in date order correctly. Is there something special about subreport sorting?
 

Gasman

Enthusiastic Amateur
Local time
Today, 10:15
Joined
Sep 21, 2011
Messages
14,038
Not that I have noticed.?
I have a main report that has two subreports and each need to be sorted by a sequence number I aloocated to the rank, and they work fine.? :confused:
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 10:15
Joined
Sep 12, 2006
Messages
15,613
OK - Solved it
The first group by parameter was "DATE", but I didn't realize it was sorting the date group by quarter, so the dates were apparently appearing in a random order - some were correct, and others were out of order - but now I realise just all within the same quarter, and THEN sorted by the second sort parameter. I selected the sort by for the DATE group as "day" instead, and it's sorting correctly now.

Can/How do I mark a thread "SOLVED"?
 

Users who are viewing this thread

Top Bottom