So I have created a report from a query and it groups by Date then Service Order Type and so I have it gives me a subtotal for each service order type and then a total for the date. The problem is that I don't need all the records of the actual service orders in between. I just need it to group buy Date then give the subtotal for each type and then total service orders for that day then proceed to the next day.
What is the best way to do that?