Duplicate information

[grecon]

Is there a way I can supress a whole line if the invoice # is a duplicate? The information reads :

Co Name address invoice# date total sale

For some reason there are some duplicates of invoice #'s and I need to supress not just the invoice# but the whole line.

Is there a formula for supressing or removing duplicate lines?

Thanks

 

[lbass]

Go into the section expert->details->suppress->x+2 and enter:

{table.invoice#} = previous({table.invoice#})

This assumes you have the report sorted on invoice#. Another approach would be to group on invoice# and then drag the fields into the group header or footer.

-LB