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

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/

Thanks for your reply, And in your example you are using ssrs2008 but i am using 2005

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