I have a report that has a table that is populated from a stored procedure showing sales by contract - one line per contract.
I need to add 2 levels of groups so that I can show Sales by Salesperson within Shop with a page break on Shop and totals at both the Salesperson and Shop levels.
I have tried adding 2 Groups and moved the table to the last Group Header section but the grouping doesn't seem to be doing anything. The report is not showing any Shop or Salesman details. The design is shown in the attached image.
What am I missing?