Last post Jun 21, 2019 08:49 AM by Wei Zhang
Jun 06, 2019 12:35 PM|jsshivalik|LINK
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
Jun 07, 2019 02:52 AM|Wei Zhang|LINK
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.
Jun 11, 2019 11:01 AM|jsshivalik|LINK
Can u pls help if i want to display the value of Row & Column group Value 's on which column user has clicked.
Jun 12, 2019 08:09 AM|Wei Zhang|LINK
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.
Jun 18, 2019 07:56 AM|jsshivalik|LINK
I have structure like this
Chris 600.00 400.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.
Jun 21, 2019 08:49 AM|Wei Zhang|LINK
According to your description,I think you could host this requirement to SSRS forums.