Passing multivalues from selected Row Group value (Network Steve Forum)

Passing multivalues from selected Row Group value

Hi Team,

Below are screenshots from my report

When a user clicks on a amount it should pass the sales regions , so that the a new detailed report opens up. Sales regions are passed when the report is in expanded view like on the right. But when its collapsed it just passes only the top most value and not all the sales region to the detailed report.

I've set this value as parameter to the detailed report

=Fields!SalesRegion.Value

How do I change this so that all the sales regions from the selected row group are passed when collapsed? I've uploaded the image in case the page does not show up

Thanks in advance for your help

May 15th, 2015 6:57pm

Set the Properties of both parameters by right clicking on the parameter and selecting Parameter Properties from the drop down list.

Check the Allow multiple values checkbox.
Select Available Values from the left hand list.
Select the Get values from a query option button.
Set the Dataset drop down list to the proper dataset.
Set the Value field drop down list to the proper field. This is the value that will be returned to the dataset that needs it.
Set the Label field drop down list to the proper field. This is the value that will be displayed to the user.

More details

http://www.mssqltips.com/sqlservertip/2844/working-with-multiselect-parameters-for-ssrs-reports/

the Properties of both parameters by right clicking on the parameter and selecting Parameter Properties from the drop down list.

Check the Allow multiple values checkbox.
Select Available Values from the left hand list.
Select the Get values from a query option button.
Set the Dataset drop down list to the proper dataset.
Set the Value field drop down list to the proper field. This is the value that will be returned to the dataset that needs it.
Set the Label field drop down list to the proper field. This is the value that will be displayed to the user.

Set the Properties of both parameters by right clicking on the parameter and selecting Parameter Properties from the drop down list.

Check the Allow multiple values checkbox.
Select Available Values from the left hand list.
- Select the Get values from a query option button.
- Set the Dataset drop down list to the proper dataset.
- Set the Value field drop down list to the proper field. This is the value that will be returned to the dataset that needs it.
- Set the Label field drop down list to the proper field. This is the value that will be displayed to the user.

Check the Allow multiple values checkbox.
Select Available Values from the left hand list.
- Select the Get values from a query option button.
- Set the Dataset drop down list to the proper dataset.
- Set the Value field drop down list to the proper field. This is the value that will be returned to the dataset that needs it.
- Set the Label field drop down list to the proper field. This is the value that will be displayed to the user.

Check the Allow multiple values checkbox.

Select Available Values from the left hand list.

Select the Get values from a query option button.
Set the Dataset drop down list to the proper dataset.
Set the Value field drop down list to the proper field. This is the value that will be returned to the dataset that needs it.
Set the Label field drop down list to the proper field. This is the value that will be displayed to the user.

Free Windows Admin Tool Kit Click here and download it now

May 17th, 2015 3:19am

This topic is archived. No further replies will be accepted.