Hi I have created 2 reports in SSRS and both have parameters. When I click the cell/value in report 1 it should take me to the report 2 and pass on the value of the report1 to report 2 parameters and generate report based on that. But currently when I click the report1 cell its taking me to the report2 but asking me to enter the parameter value again.. What am I doing wrong? additional info - these reports are created using AS cube Any help on this greatly appreciated thanks,

I hope you navigate to report 2 by setting up the 'Go to report'. 1. When you setup, after selecting the report, in the bottom part of that dialog, you would notice 'Use these parameters to run the report' and an 'Add' button just below. Click on 'Add' button 2. Select the parameter of the report that you want to navigate to 3. On the right side set the value you need to pass from the report1. For this, in your case you would refer to the parameter in the report1 like Parameters!MyParam.Value (Provide you parameter name in place of MyParam). 4. You can click add and repeat steps 1to 3 in case you need to send more parameter values to report2. Hope this helps. Please feel free to discuss if you need any further help. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Hi SSRSuser, Besides Bilal's reply, I just add some additional information about How to: Add a Subreport and Parameters (Reporting Services), please see: http://msdn.microsoft.com/en-us/library/ms160348.aspx Similar thread http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/2e11e6cd-3796-4bc5-b814-6c37322896fa Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.