dssisupport
asked on
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Thanks so much.
select yourfield, count(*) from yourtable group by yourfield