How to suppress object on last record of a Group?

[TatyanaH]

Hello,

I hope somebody could help me with this...

I have a problem with my report where I have one Group #1 (Order). In that group I have 2 detailed sections.
Details a and Details b.
Details a - is line items of the grouped order
Details b - order comments.
Order comments supplied to me in the separate field called comments and are always the same for every record of the grouped order. But the way they wanted me to display them is after the last line item of the order. Also they could be really long and they wanted me to page through the order. So I figured that I will have a details section b and have that section be suppressed like so:
OnLastRecord = false or {InvoiceTable.COMMENTS} = ''
Everything works great while I have one order for the customer. Once I have 2-3 or more the order comments for that particular order are not printing...and I know why, cause it is looking for the OnLastRecord of the whole report and not my Order Group.

Does anybody know how to determine wheather it is the Last Record of the Group and not the whole report?

Thank you in advance

Tatyana

 

[lbass]

Try a suppression formula like this:

not onlastrecord and
{table.order} = next({table.order})

-LB

 

[TatyanaH]

Oh wow! Thank you so much! That worked!

I saw you had helped to a lot of people here