Grouping in report for Sql server 2008 R2

  • I am trying design a report as attached grouping format on sql server 2008 R2.

    I would like to know how to design the report with the data by grouping levels.

    Thanks.

  • Sorry I would love to help, but cannot understand what you want. You seem to have a report produced and want to know how to produce it.

    Is the bitmap a picture sent from someone else (e.g. a request) that you need to produce. If so then :-

    - create a tablix and add the base (lowest level) detail to the details row [one with 3 lines].

    - using the row group section right click and add a Parent Group, and select the PSC_Category column and add a group header.

    - using the row group section right click on the PSC_category and add a Parent Group, and select the Provider column and add a group header.

    The tablix now should resemble the bmp (just needs colour).

    Fitz

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply