How to avoid duplicate lines withone-to-many table link

[izakwould]

I have linked two tables in a report, a customer table and a contact table. In the customer table, there is only one record per customer number, but in the contact table, there can be multiple contacts per customer number (or in some cases no contacts).

I'm trying to figure out how to link them so that I don't get duplicate lines on the report. I only want to have one line on the report per customer number, instead of having one line per every record in the contact table (which results in several lines per customer number).

Any suggestions?

 

[JoeCrystal]

Group on customer, suppress detail, and display customer & contact info in the group footer or header.

 

[izakwould]

Is there a way to do it with formulas instead of grouping? If I use grouping, it limits my ability to group based on other stuff...

 

[JoeCrystal]

You can do via formula using the Next/Previous function.

It is also possible to group on formula.