I have Matrix report which has Row Group = Location & 2 Column Groups Product & Month .
I want when user clicks on Column what is his Row Value & Columns value (Product & Month). Is it possible. I want to pass these as Parameters to subreport
According to your description, you could add value of field in static field to sub report by following steps as bleow:
In Design view, right-click the subreport and then clickSubreport Properties.
In theSubreport Propertiesdialog box, clickParameters.
ClickAdd. A new row is added to the parameter grid.
In theNametext 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 theValuelist 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.
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 clickDelete.
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.
According to your description, I suggest that you could post this requirement to SSRS msdn forums ,they are specialized in dealing with report related issues.
Member
140 Points
518 Posts
Matrix Report
Jun 06, 2019 12:35 PM|jsshivalik|LINK
Hi
I have Matrix report which has Row Group = Location & 2 Column Groups Product & Month .
I want when user clicks on Column what is his Row Value & Columns value (Product & Month). Is it possible. I want to pass these as Parameters to subreport
Thanks
Participant
1300 Points
522 Posts
Re: Matrix Report
Jun 07, 2019 02:52 AM|Wei Zhang|LINK
Hi jsshivalik,
According to your description, you could add value of field in static field to sub report by following steps as bleow:
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.
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.
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.
Here is the link, I hope it could help you.
https://docs.microsoft.com/en-us/sql/reporting-services/report-design/add-a-subreport-and-parameters-report-builder-and-ssrs?view=sql-server-2017
Best Regards
Wei
Member
140 Points
518 Posts
Re: Matrix Report
Jun 11, 2019 11:01 AM|jsshivalik|LINK
Hi Wei
Can u pls help if i want to display the value of Row & Column group Value 's on which column user has clicked.
Thanks
Participant
1300 Points
522 Posts
Re: Matrix Report
Jun 12, 2019 08:09 AM|Wei Zhang|LINK
Hi jsshivalik,
According to your description, I suggest that you could post this requirement to SSRS msdn forums ,they are specialized in dealing with report related issues.
Here is the link,I hope it could help you.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlreportingservices
Best Regards
Wei
Member
140 Points
518 Posts
Re: Matrix Report
Jun 18, 2019 07:56 AM|jsshivalik|LINK
Hi Wei
I have structure like this
Mumbai Delhi
Chris 600.00 400.00
Brian 800.00
I want when user clicks on 400 i want to display Values Chris & Delhi in textbox
If User clicks on 800 then Brian & Mumbai should get displayed.
Thanks
Participant
1300 Points
522 Posts
Re: Matrix Report
Jun 21, 2019 08:49 AM|Wei Zhang|LINK
Hi jsshivalik,
According to your description,I think you could host this requirement to SSRS forums.
Here is the link,I hope it could help you.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlreportingservices
Best Regards
Wei