How do I remove the "grouped' object from a query? It is redundent to have the grouped item in the query results (It is implied since that is the field you grouped on).
I'm sure that I am missing a setting because it should not work this way (at least I hope it doesn't).
For this type of data in a grid:
Type Number State
Online 1234 CA
Offline 2345 FL
Online 3456 GA
I would expect to see this:
Online
1234 CA
3456 GA
Offline
2345 FL
but I am seeing this:
Offline
Online 1234 CA
Online 3456 GA
Online
Offline 2345 FL
Any help would be appreciated.