pass multi value parameters

[woyler]

Hi All,

Is it possible to pass a multi value parameter from one report to another using the "jump to report" feature?

ie;



I have report A that has a mutli value parameter (para1). This report has a link with the action property set to jump to another report(Report B). Report B requires the same multivalue parameter. I have tries setting the parameter in the interface as well as trying the join function. Nothing seems to pass the values correctly.



regards

 

[woyler]

Nevermind. I worked it out. The answer is;
=Split(Join(Parameters!ParaName.Value, ","),",")

 

[SQLBI]

Hi,

This is a tricky one, but possible (exept if Oracle 8 is your backend in which case you can't use Multi-Value parameters at all).

In both of your reports, make sure you have created a multi-valued parameter, containing the same values, i.e. using the same SQL Query or manual entries.

In the parameters section of the Jump to Report action, set Parameter Name to the name of the parameter in the report you're jumping to. Set the Parameter Value to Parameters!<ParameterName>.Value where <ParameterName> is the name of the parameter in your first report.

Then in your second report, ensure that the WHERE clause of your query uses IN and not = e.g.

SELECT *
FROM MyTable
WHERE MyValue IN (@MyParameter)

This should then pass the parameter value from your first report to your second report generate the report.

Let us know how you get on.

Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem

 

[woyler]

Hi Leigh,
Thank you for your response. I had the query working fine. My issue was the passing of the parameter between reports. My understanding is the multi value in sqlrs is handled as a string array and you cant just pass the array. I did work it out using the code I posted above.
Thanks again,
Bill

 

[SQLBI]

No worries Bill, glad you're sorted.

Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem