Parameter Passing in SSRS Drillthrough Reports

Hi,

I am working on Sql Server 2008 R2, I want to know how to pass parameters in SSRS drill through reports.

Reparts are fetching data from SSAS Cubes. Early responses will be highly appreciated.

Thanks,

Sumit.

1st, your subreport must have parameters.

2nd, in your master report, for example in a cell of a table, go to properties and go to Action. Select Go to Report, specify the report name and finally add parameters. Note that after you select the report name and click add parameters, they will be available at the Name combobox.

Let us know if you need further attention.

Thanks Marco, Actually I have already tried the above steps, its just that the sub report is uhnable to receive the parameter from main report. I have tried hiding the parameter in sub-report. 

In the main report, Action, Go to Report, parameter value of sub report is =Fields!Delivery_Branch.UniqueName

After clicking on the main report, its going to the sub report but asking me to select the parameter from dropdown.

Hidding parameter will not solve your problem.

You subreport parameters has available values? Does the Fields!Delivery_Branch.UniqueName maps with any of those values?

What do you have under "alow null values" and multiple values?

It sounds like the parameter might not be mapped correctly in the main report. It seems like you have the value correct but did you pick the parameter name from the drop down? Check out this link where it uses maps but you can look at the images to see if you have everything set up correctly. http://www.bidn.com/articles/ssrs-development/206/rock-your-reports-series-3-of-3