question

manuu avatar image
manuu asked

Drill down in ssrs based on column values

I need to make a drill down report based on column values. I have already created report but I need to implement drill down in my report. My column values are like below based on which I need to drill down my report. Column values are: Products (GL), NII, NIR, Products (Non-GL), NIIT, NIRT, WIP, No.Of Prospect NII, No.Of prospect NT, and so on... Now I have to just implement a drill down such that If I click on 'Products (GL)', NII and NRR should expand . If I click Products (Non-GL), NIIT and NIRT should expand. And If I click WIP, No.Of Prospect NII and No.Of prospect NT should expand. basically ssrs report should be structured like: +Products (GL) +Products (Non-GL) +WIP So If I click on +Products (GL), those 2 value should expand. Can we hardcode, If column value is 'Products (GL)', than expand into NII and NRR. If column value is 'Products (NonGL)', than expand into NIII and NIRT and so on? If yes than how? Could you please help me out how to achieve this, As I am very new to SSSRS.
ssrsssrs-2008ssrs-2008-r2
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.