Reports Parameters

I use the Reports Servers Design to Design My report, but I need to use multi value fot Report Parameters, But Don.t to do.

Mulit Parameters (Type = 'A' , 'B')

A Value are '1' , '2'

B Value are '3' , '4'

I use SQL Script to Run

Select * From XXX

Where A IN (@.Type)

@.Type may be 1,2,3,4 or 1,2 or 3,4

How to slove

Thanks

this one must work for you:

select the parameter from the Report Parameters menu check the multi-value and then select the radio button non-queried, this should have you a list box with two columns, list all the possible values and labels for what do you want to be visible in the control. Then you can also set the default value you want to in the panel below it.|||

hi BLueDeViL

The Values could store 2 Values like value=1, 2 lable=A

thanks

william

|||

William,

I got your point, and if that's so..i think it is not yet possible. And even the logic of having 2 values for a single label..even the compiler will be confused.

Because take a look at the scenario, what if the user selects 'A' in the multivalue control? Do you think there is a logical way of determining the value, if they both have the same label? The label acts as the index, and that index is only referring to a one dimensional array! If the reporting services shall have a multi dimensional array, where in your case should include 2 values in a single index..this shall be done accordingly.

Hope you got my point. As of now I don't know if that is already possible, but as far as I know it is not yet implemented!

Thanks and more power,

Mark Guerra