Unique forumla

[Zugdud]

Greetings all, not sure if theres a built in function for this or not but all I want to do is compare each record to the previous record and only print unique/distinct records based on 1 field. Any way to do a distinct on one field? thanks

 

[lbass]

If you go to the section expert (format->section)->details->suppress->x+2, you can enter:

{table.field} = previous({table.field})

This will suppress the entire row if this field is repeated.

-LB

 

[Zugdud]

Great, thanks a lot!