Distinct Records

[faush]

Hi,

I have a report that lists out members with their designations, ID # and company. There can be several different designations, in which the name is then being printed twice, or up to 4 times on the report, depending on how many professional designations the member holds.

How do I get the name, ID#, company info, to just print one time, regardless of how many designations the member holds?

Thanks!

 

[John43]

Try grouping by name.

 

[olichap]

If the Name, ID#, Co. Info are always the same you could try putting the designations in the Details section and the other data in a Group section. This will give you up to 5 lines per member, but if you don't need the designations just suppress the Details section, thus giving you a report with three fields listed above.

You may have to play with the grouping a bit but this should work for you.

Oliver

 

[faush]

Thanks, this worked!