Solved

Ignore duplicate records crystal reports

Posted on 2006-06-26
2
335 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:whiwex
2 Comments
 
LVL 7

Accepted Solution

by:
jaanth earned 500 total points
ID: 16989947
You need to create a group on the vendor, which will add  group header and footer sections on the report. Suppress the group header section and detail sections. In the group footer, you can insert total values of the certificates.

When you run the report, it will total the details, but not display them.

hope this helps.
jaanth
 
0
 
LVL 5

Expert Comment

by:t_itanium
ID: 16990197
you have tospecify a GROUP BY statement in your SQL query.....
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This is about my first experience with programming Arduino.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question