Understanding Grouping in SQL Reporting Services 2005 Reports -

i have page header, body , page footer section, can't figure out how add additional 'group' sections sql reporting services report design (rdl) in visual studio 2005.

take example: have dataset select department, employee salary employees order department, employee. want make report showing each employee's salary along department , company wide totals.

in similar report designers defining grouping in report on department field. have department header section drop textbox department field, detail section drop textboxes employee , salary fields, department footer section drop textbox aggregate sum of departments salary, , (report) footer section drop textbox aggregate sum of employees salary.

i have found table control in toolbox - can create "rows" match section definitions mentioned above, table control wants tightly follow it's rows , columns - cannot freely drop textbox in section, must size fit 1 cell in table. may great situations, not mine.

is table control only/correct way grouping here, or there way expand beyond page header/body/page footer sections?

it seems can done list control.

first place list item in report body. assigned datasetname , assign grouping value (in example 'department').

then place second list item inside first - must dropped child item, not overlapping. same dataset, no grouping.

everything placed in parent list above child list appears header, while placed below appears footer.