Link to home
Start Free TrialLog in
Avatar of jspc
jspcFlag for Australia

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
Avatar of Mike McCracken
Mike McCracken

Your group 1is the Document Number
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
Avatar of jspc

ASKER

NA
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members 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.