locked
how to pass parameters to ssrs sub reports RRS feed

  • Question

  • hi

    pls any body help me how to pass multiple parameters to the sub report

     

    Wednesday, March 23, 2011 7:24 AM

Answers

  • 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
    • Proposed as answer by Albert Ye Thursday, March 24, 2011 12:57 PM
    • Marked as answer by Challen Fu Tuesday, April 5, 2011 10:28 AM
    Thursday, March 24, 2011 4:24 AM

All replies

  • 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
    Wednesday, March 23, 2011 8:50 AM
  • 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

    Wednesday, March 23, 2011 9:31 AM
  • 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
    • Proposed as answer by Albert Ye Thursday, March 24, 2011 12:57 PM
    • Marked as answer by Challen Fu Tuesday, April 5, 2011 10:28 AM
    Thursday, March 24, 2011 4:24 AM