Crystal Reports One to many problem

I've got a Clients table, and an Address table, related One (Client) to Many (Address).

I want the report to show every client, but what it's doing is showing the same client as many times as there are addresses for them.

So if I've got Steve Smith, and he has 3 addresses, how can I get it to only show Steve Smith once and show the first address only instead of giving me the data 3 times?

tmccrankAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RickJCommented:
This is one way you can do it;
Have the customer details and address in the details section, (like you have now)
Create a group on the customer name/id whatever it is.
Move the customer details and address to the group header.
Then suppress the details section.
This should then show only the first address antry for each customer.
0
mlmccCommented:
Agree.
mlmcc
0
tmccrankAuthor Commented:
Any way of doing that but keeping the Address in the Details?
0
mlmccCommented:
You could use the TOP N expert to choose the TOP 1.

Another way is to control suppression yourself

In the group header add a formula
WhilePrintingRecords;
Global BooleanVar SuppressDetails;
SuppressDetails := False;
''

In the detail section
WhilePrintingRecords;
Global BooleanVar SuppressDetails;
SuppressDetails := True;
''

Right click the details section in the left margin
Click SECTION EXPERT
Click the formula button to the right of SUPPRESS
Global BooleanVar SuppressDetails;
SuppressDetails

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.