Multi Value Parameters on Drill Through Reports

Question

Hi,

I am currently using SSRS 2008 and have two reports one that passes data through to the sub report.

I have a Building Parameter that passes through the the sub report, the problem occurs when i select all from the mutli value parameter in report 1 the buildings are not passed through to the sub report.

If i go through and deselect 'Select All' and select all the options the Buildings are passed through to the report, does anyone know why when have 'select all' on the main report the buildings will not pass through?

Thanks

Dan 

Answer 1

Dan, I think you are doing it with following syntax;

=Parameters!ParameterName.Value(0)

remove the index number like this;

=Parameters!ParameterName.Value

regards,

Noman Rao

---

NOman Rao

Answer 2

Hi there

First of all can you please let me know that your sub report is also accepting multivalued parameter?

If that is the case then please pass sub report a parameter as Noman has suggested

=Parameters!yourParameterName.Value

I hope this will resolve your problem

Many thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 3

Hi Guys,

The main report action on the cell within a table was taking the =Parameters!yourParameterName.Value, the only time the issue occurs is when the select all option is selected. If i select multiple Buildings as it were (what the parameter is based on ) this works.

Thanks

Dan

Answer 4

Hi there

please change the length of the sub report parameter to a bigger length as it seems to me when you select all option your string value is big enough and not all values has been passed to the query . It does happen to me as well lot of time in the past

I hope it will resolve the problem.

Many thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 5

Hello Dan,

We should use the following expression to pass the multiple-value parameter values from main report to the subreport, please see:
=Split(Join(Parameters!Your_Parameter_Name.Value, ”,”), ”,”)
Please refer to the screenshot below:


If you issue still persists, please post the drill through expression and more information to us. We will help you to solve it.

Regards,
Bin Long

 

---

Bin Long

TechNet Community Support