Showing distinct field values and counts

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.
dssisupportAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
in sql, I would do:
select yourfield, count(*) from yourtable group by yourfield
0
 
dssisupportAuthor Commented:
Perfect! Thanks so much.
0
All Courses

From novice to tech pro — start learning today.