CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-2012ssrs-2008-r2ssrs-tablix
UpwardD
UpwardD

Reputation: 767

Issues with Passing Multi-value Parameters to a Drill through Report

I have two reports were I pass multi-valued parameters to it's underlining data and both reports work very well independently. The parameter strings are being split using the function dbo.UTILfn_Split. When trying to drill from the main or Summary report into the sub or Detailed report all other parameters field in the report are populated except the multivalued parameter field. The parameter lists or value are listed in the detailed report but not selected and therefore cannot run the report even though the detailed report parameter property is set to allow multiple values. In both reports, the where clause is set "IN" not "=." How do I fix this?

Upvotes: 0

Views: 1637

Answers (1)

Amazigh.Ca
Amazigh.Ca

Reputation: 3543

In your Summary Report, when you pass the parameter to the sub or detailled report, the passed value parameter should be like this expression: 

=join(parameters!yourMultivaluedParameter.Value,",")

after that, you pass the name of the parameter to the corresponding parameter in the dataset Detailled report. In your SQL (SP), get the multivalues of the parameter by spliting it with your function like following, depending of the result of your function, for exemple: 

INNER JOIN dbo.SplitFunction( @yourMultivaluedParameter,',')  tmp on tmp.yourColumn = ...etc...

Hope it helps...

Upvotes: 0

Related Questions