November 4, 2013 at 7:08 am
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
November 4, 2013 at 2:40 pm
Given that the Groups in SSRS work on a hierarchy model, you may not meet the requirement with Single Tablix.
November 5, 2013 at 5:34 pm
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