how to pass parameters to ssrs sub reports
hi pls any body help me how to pass multiple parameters to the sub report
March 23rd, 2011 3:38am

1: Right click on Sub-Report -> Sub Report Properties->select the report from dropdown 2: select Parameteres->Add->select ParameterName from dropdown which are created in Sub-Report and select value to pass. http://msdn.microsoft.com/en-us/library/ms160348.aspx Nanda
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 5:04am

hi thanq, now i am able one parameter value, i want to send the parameter values like this 1. my Main report has report parameter A which is a multi value parameter. i want to pass it to SubReport1 which has a report parameter B which is also defined as multi value parameter. and my Main report has no report parameters. and in my SubReport1 with a report parameter B defined as multi value parameter. i want to pass e.g. three selected values "A", "B", "C" as parameter values to the subreport how can i acheive this
March 23rd, 2011 5:46am

Add Parameter with hidden and multi value and add the values from dataset to the parameter. Now pass the hiddent parameter to the sub-report with expression =Join(Parameters!Param.Value,",")Nanda
Free Windows Admin Tool Kit Click here and download it now
March 24th, 2011 12:43am

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

Other recent topics Other recent topics