I’m going to try to really simplify my issue here. Basically, I’m looking to create a report (I assume summary grid?) that with several rows, each showing the number of database rows that contain a particular value.
Support I have the database:
id, letter, color
1, a, blue
2, a, red
3, a, green
4, b, blue
5, b, blue
6, c, red
etc
Now I’d like a report that says:
Number of As: 3
Number of Bs: 2
Number of Cs: 1
Number of Blues: 3
Number of Reds: 2
Number of Greens: 1
Thanks in advance for your help!