How to create group by reports in ssrs

  • Hi All

    my table have data is

    County          State      Details
    India              AP         helloooooo
    India              TN         Hiiiiiiiiiii
    India               TS         Heloooooooo
    US                  NE        Hiiiiiii
    US                  GE        heloooo
    UK                  LO        hhhhhh
    UK                  BR       helooooo

    but i want dusplay the data like

              Country : India

    State      Details
     AP         helloooooo
    TN         Hiiiiiiiiiii
    TS         Heloooooooo

             Country : US
    State      Details
    NE        Hiiiiiii
    GE        heloooo

          Country : UK
    State      Details
     LO        hhhhhh
     BR       helooooo

    please help me asap

    Regards
    Pols

  • Insert a List object into your report, and set it to use the required dataset in its Tablix Properties. Then create a grouping on that list for your Country field (which you would create in the Row Groups pane, displayed under your design pane by default).

    Then all you need do is add a tablix within your List Object, and it'll create a separate tablix for each Country Group.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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