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?
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.