Saturday, February 25, 2012

Multiple Select

Hi,

In my report i have a paremeter which is a dropdown list showing alla available values.Now i want to select multiple values.The parameter is not multi valued.

From the following link:

http://www.ssw.com.au/ssw/Standards/BetterSoftwareSuggestions/ReportingServices.aspx#RichTexbox

Multiple select in Parameters Is fixed in Sqlserver reporting services 2005.

Iam using 2005 version,But i can't able to select multiple values by holding Ctrl key.How to achieve this.If we able to select the multiple values,In wgich format the selected value is passed to the Stored Procedure,It is same the way as selecting multiple values from Multi valued Parameter.

Please help me.

Thanks in advance

You should check "Multi-Valued" check-box in parameter dialog box. Otherwise you will not be able to select more then 1 value. After that you should make ability to process your parameter accordinally whereever you use it. It's wath was NOT fixed in 2005 this ability was added in 2005. And - you can't use CTRL for selecting values in report designer or viewer, you should use check box near parameter's value or you should write some code for this...|||

Thanks you very much for your response.

Hi,

In my report,I have multivalue parameter for this parameter the Available values are from the Dataset.Suppose the dataset contains Names like this:

'AL - Alabama Center (Tuscaloosa)',

'AL - RegionalControl Center (Birmingham)',

'AR - Arkansas Poison & Rock)',

'Arizona Department of Health'

But my problem is the Multivalue parameter TextBox is of fixed size.Now i want the size of the text box to the size of the name which is of length long in the Name.

Whether it is possible or not.

How to achieve this.

|||

Basically I faced the same issue and I didn't find decisions yet... If you find it - please let me know..

Thanks

|||

Hello,

Are you running into http://support.microsoft.com/kb/919478/

Thanks

No comments:

Post a Comment