Crystal Reports Listing

I have a report where it shows all the clients that I sold something.

Is there anyway to show all the clients just once so I can make a grand total of each one?

Ex:

CLIENTS     DOCUMENT     VALUE
Client A      1                         10000
Client A      2                         30000
Client A      3                         40000
Client B      1                         500
Clinte B      2                         2000

Grand Total Per Client
CLIENT      N° OF DOCS      TOTAL
Client A     3                          80000
Client B     2                          2500
Gabriell PortoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

mlmccCommented:
Add a group on the client and put a summary of the values in the group header.

TO get the summary
Right click the value
Click INSERT --> SUMMARY
Select it to put it in all groups
Drag the summary from the group footer to the group header

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
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Insert, CrossTab...
0
Gabriell PortoAuthor Commented:
Sorry for the time without answerin!

@mlmcc I didn't quite understand. Could you elaborate for me?

@Ido Millet That almost got it, althought the values that I wanted became just columns headers, not columns values.
0
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
If you need rows in the CrossTab, change the CrossTab design to include rows.
0
Gabriell PortoAuthor Commented:
Thanks, that worked great.
0
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
Crystal Reports

From novice to tech pro — start learning today.