SSRS report grouping

  • Hi,

    I am cregrating a report which shows sales information by country.

    I have result set like

    Country, BusinessType, NetSales

    When the user clicks on Country, drill down to BusinessType.

    It is working well so far.

    Now, I got another requirement.

    If I click on BusinessType, I need to show details by all countries where the business exists.

    Means, the same business might exist in multiple countries.

    Example:

    UK ABC Business 1000.00

    UK XYZ Business 2000.00

    France ABC Business 1500.00

    France PQR Business 1000.00

    Current report showing

    UK

    ABC Business 1000.00

    XYZ Business 2000.00

    France

    ABC Business 1500.00

    PQR Business 1000.00

    My new requirement is, when I click on ABC Business again, I need to show

    UK

    ABC Business

    UK 1000.00

    France 1500.00

    Is it possible with single dataset and one tablix?

    Thanks

  • Given that the Groups in SSRS work on a hierarchy model, you may not meet the requirement with Single Tablix.

  • Which version of SSRS are you using? There is a function that came out in SSRS 2008 R2 called LookupSet. It might do what you need. It's been a while since I've tried to use it. I'll take a look and post something.

    Mickey

    Mickey Stuewe
    Sr Database Developer
    My blog
    Follow me on twitter: @SQLMickey
    Connect with me on LinkedIn
    --------------------------------------------------------------------------
    I laugh loudly and I laugh often. Just ask anyone who knows me.

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

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