In Design view, right-click the subreport and then click Subreport Properties.
In the Subreport Properties dialog box, click Parameters.
Click Add. A new row is added to the parameter grid.
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.
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.
Repeat steps 3-5 to specify a name and value for each subreport parameter.
To delete a subreport parameter, click the parameter in the parameter grid, and then click
Delete.
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.
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Member
504 Points
1776 Posts
SubReport
Dec 01, 2017 06:23 AM|JagjitSingh|LINK
Hi
In Main Report i have 2 parameters . But in one Sub Report i want to pass 3 parameters with Multiple Vlaues
Thanks
Contributor
2990 Points
1210 Posts
Re: SubReport
Dec 01, 2017 07:18 AM|Deepak Panchal|LINK
Hi JagjitSingh,
To specify parameters to pass to a subreport
In Design view, right-click the subreport and then click Subreport Properties.
In the Subreport Properties dialog box, click Parameters.
Click Add. A new row is added to the parameter grid.
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.
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.
Repeat steps 3-5 to specify a name and value for each subreport parameter.
To delete a subreport parameter, click the parameter in the parameter grid, and then click Delete.
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
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.