suppress all but the last group 1

[voodoojon]

I need to suppress everything but the last group footer on the report. Alternatively is there a formula I could make that, say returns 1 if it's the last group, 0 otherwise.

Jon

One day I will find a signature worthy of this space. That day has not yet come.

 

[bdreed35]

Report menu, Section Expert.
Highlight the Group Footer, then click the X+2 to the right of Suppress (No Drill Down).
Copy this line into the editor:

not onlastrecord

Save and Test.

~Brian

 

[voodoojon]

Cheers bdreed35 for the quick, correct, concise answer. If only I could defer all my thinking to Tek Tips! life would be so easy

Jon

One day I will find a signature worthy of this space. That day has not yet come.