Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Showing distinct field values and counts

Posted on 2014-04-04
3
Medium Priority
?
331 Views
Last Modified: 2014-04-04
I have a text field in sql table that may or may not have a value (if not it would be NULL) and I have a report that shows the content of that field in Group 1. What I need now is a way to show all of the distinct values that were found and also show a count of how many of each one were found at the end of the group report. I am running Crystal reports 11.5. Any help would be greatly appreciated.
0
Comment
Question by:dssisupport
3 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 39979178
in sql, I would do:
select yourfield, count(*) from yourtable group by yourfield
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39979187
Have you tried a cross tab?

Click INSERT  --> CROSS TAB
Drag into the report footer
Right click the Cross Tab in the upper left corner
Click CROSS TAB EXPERT
Rows - FIeld you want
Summarized field - Field you want  - make sure it says COUNT
Click OK

mlmcc
0
 

Author Closing Comment

by:dssisupport
ID: 39979209
Perfect! Thanks so much.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Integration Management Part 2
Screencast - Getting to Know the Pipeline
Suggested Courses

783 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