Subreport Sorting (1 Viewer)

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 03:41
Joined
Sep 12, 2006
Messages
13,892
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, 03:41
Joined
Sep 21, 2011
Messages
5,798
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, 03:41
Joined
Sep 12, 2006
Messages
13,892
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 (Users: 0, Guests: 1)

Top Bottom