Selection option for SSRS
Hi experts I am new to SSRS. I created an example report, it contains employee names and their salary in rows and in colums contains Year like 2009 2010 abc 150000 200000 xyz 200000 225000 Now I want user to select for which employee he wants to see the data Thanks in advance Sushmitha
November 13th, 2010 2:01am

Hi, You need to create a drill through reports which display data for employee. this report will have a employee parameter and linked to your current report. On you report user will click on Employee name and will jump to drill through report and can see data he wants filter based on employee he selected. Following is an example of the same http://shahfaisalmuhammed.wordpress.com/2010/01/09/passing-parameters-to-a-drillthrough-report-in-ssrs/ Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 13th, 2010 6:05pm

Thanks for your reply, And in your example you are using ssrs2008 but i am using 2005
November 15th, 2010 1:59am

Hi Sushmitha, If Gaurav Gupta understands your needs correctly that users can click an employee name in the matrix and navigate to another report, please read the article about How to Add a Drillthrough Report Link in Reporting Services 2005: http://msdn.microsoft.com/en-us/library/ms159847(v=SQL.90).aspx However, if you only need to a specific employee in the matrix, we can first add a parameter to let user select an employee, and then filter the report based on the parameter. As an example, please refer to the link below: http://msdn.microsoft.com/en-us/magazine/cc188691.aspx#S4 If you have any more questions, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 4:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics