locked
SubReport RRS feed

  • Question

  • User-1499457942 posted

    Hi

     In Main Report i have 2 parameters . But in one Sub Report i want to pass 3 parameters with Multiple Vlaues

    Thanks

    Friday, December 1, 2017 6:23 AM

Answers

  • User347430248 posted

    Hi JagjitSingh,

    To specify parameters to pass to a subreport

    1. In Design view, right-click the subreport and then click Subreport Properties.

    2. In the Subreport Properties dialog box, click Parameters.

    3. Click Add. A new row is added to the parameter grid.

    4. In the Name text box, type the name of a parameter in the subreport or choose it from the list box. This name must match a report parameter, not a query parameter, in the subreport.

    5. In the Value list box, type or select a value to pass to the subreport. This value can be static text or an expression that references a field or other object in the main report.

      Note:-

      In Report Builder, if a parameter is missing from the Parameters list and the subreport has a default value defined, the subreport will be processed correctly.

      In Report Designer, all parameters that are required by the subreport must be included in the Parameters list. If a required parameter is missing, the subreport is not displayed correctly in the main report.

    6. Repeat steps 3-5 to specify a name and value for each subreport parameter.

    7. To delete a subreport parameter, click the parameter in the parameter grid, and then click Delete.

    8. To change the order of a subreport parameter, click the parameter, and then click the up button or the down button.

      Changing the order of a subreport parameter does not affect the processing of the subreport.

    Reference:

    Add a Subreport and Parameters (Report Builder and SSRS)

    Regards

    Deepak

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, December 1, 2017 7:18 AM