I have created SQL views and then built my model on model views which link entities together.
When i run the report builder i can group by fields, but the sub totals no longer work. When i first started messing about with report builder, the sub totals magically appeared when i was dragging things on to the grid... Now they just do not appear. I have made sure Show Group Totals is ticked.
Is there something wrong with the model? Or is it something i've missed