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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you have tospecify a GROUP BY statement in your SQL query.....