title: Understanding Grouping in SQL Reporting Services 2005 Reports
body: <p>I have a Page Header, Body and Page Footer section, but I can't figure out how to add additional 'group' sections to a SQL Reporting Services report design (rdl) in Visual Studio 2005.</p>
  
  <p>Take this example: I have a dataset <code>SELECT Department, Employee Salary FROM Employees ORDER BY Department, Employee</code>. I want to make a report showing each employee's salary along with department and company wide totals.</p>
  
  <p>In similar report designers I would do this by defining a grouping in the report on the Department field. I would then have a Department Header section to drop a textbox for the department field, a Detail section to drop textboxes for the Employee and Salary fields, a Department Footer section to drop an textbox for the aggregate sum of the departments salary, and finally a (Report) Footer section to drop a textbox for the aggregate sum of all employees salary.</p>
  
  <p>I have found the Table control in the toolbox - I can create "rows" which match the section definitions I mentioned above, but the table control wants everything to tightly follow it's rows and columns - I cannot freely drop a textbox in a section, it must exactly size itself to fit one cell in the table. This may be great for some situations, but not mine.</p>
  
  <p>Is the Table control the only/correct way to do grouping here, or is there a way to expand beyond the Page Header/Body/Page Footer sections?</p>