jspc
asked on
Sort order of text (comment lines)
Hello,
I have a tax invoice crystal form and it is groups by product code then each field is summarised.
Since taking your advice on implementing this I have now noticed the text (comment) lines do not appear as they are entered in chronological order.
The last one is missing. Please see attached PNG files which show this. The form is attached with saved data.
Your help would be appreciated.
Thanks.
CorrectOrderInDatabase.png
LastTextLineMissing.png
SalesInvoiceBackorderLandscapeAWWSum.rpt
I have a tax invoice crystal form and it is groups by product code then each field is summarised.
Since taking your advice on implementing this I have now noticed the text (comment) lines do not appear as they are entered in chronological order.
The last one is missing. Please see attached PNG files which show this. The form is attached with saved data.
Your help would be appreciated.
Thanks.
CorrectOrderInDatabase.png
LastTextLineMissing.png
SalesInvoiceBackorderLandscapeAWWSum.rpt
ASKER
NA
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
The second group is on the Line code.
Your 2 highlighted records are in the same group2 so only the first one shows in the group 2 header
Is there a datetime on the records that you can group by to get them in the correct order?
or some other field that like a line number? maybe sequence no or sequence no2?
You could try grouping by that then by the line code
mlmcc