Grouping in a Report
The default grouping in SSRS 2008 includes keeping the group by field as a static value in the far left hand side of my report. I want the grouping to be a line across the top of the records it groups.
For example, if I group sales people by manager I want to see:
Manager 1 ------------------------------
Joe
Sam
Sue
Manager 2-------------------------------
Jim
Timmy
Billy
Right now, my report is grouping as follows:
Manager 1 Joe
Sam
Sue
Manager 2 Jim
Timmy
Billy
Please help! Thanks!
October 5th, 2010 10:18pm
Rt click the ROW GROUPS
Add Group > Parent Group
Group By > your group Col. Add Group Header
Delete the first column in the TABLIX
Map the middle row to your group col, the detail row to your detail data.
Free Windows Admin Tool Kit Click here and download it now
October 6th, 2010 1:39am