locked
Grouping in a Report RRS feed

  • Question

  • 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!

     

     

     

     

     

     

    Tuesday, October 5, 2010 7:18 PM

Answers

  • 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.

     

     

    • Proposed as answer by Jerry Nee Thursday, October 7, 2010 2:06 AM
    • Marked as answer by Jerry Nee Friday, October 15, 2010 9:18 AM
    Tuesday, October 5, 2010 10:39 PM