Link to home
Start Free TrialLog in
Avatar of whiwex
whiwex

asked on

Ignore duplicate records crystal reports

I have a report in Crystal Report 10.
In the database I have 3 fields Vendor, Certificate#, and Value
The vendor is the same for any of the certificate#'s.
I want to create a report that shows each vendor with their total number of certificate and the total value.
The problem I have is I can't get a single line for each vendor in the report. I get a line for every certificate. If I suppress duplicates I get blank lines in the report.
How can I configure a single line for each vendor with each vendors totals?
Thanks
ASKER CERTIFIED SOLUTION
Avatar of jaanth
jaanth

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
you have tospecify a GROUP BY statement in your SQL query.....