how to add parameters with mulitselection enabled in ssrs 2008

Posted by Sheikh Usman on Stack Overflow See other posts from Stack Overflow or by Sheikh Usman
Published on 2010-05-07T14:53:40Z Indexed on 2010/05/07 14:58 UTC
Read the original article Hit count: 232

Filed under:

ssrs-2008

|

parameters

|

multipleselection

Hi,

I have a table called Resource, and i am making a line chart (the chart is complicated, so just assume its a simple xy line chart).

I want to execute the report with different resources. I have added a new parameter and bound it to a dataset to return a dropdownlist of resource names.

Can i do a mulitiple selection of resource. for example if i want to make chart with ResourceA and ResourceB, only, can i select these two resources from the dropdownlist of parameters.

cheers,

Oz

© Stack Overflow or respective owner

Related posts about ssrs-2008

How to convert SSRS 2008 Server reports to SSRS 2008 Client Reports

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a large SSRS 2008 Server Report Project (more than 200 reports). Currently my companystrategy has been changed and we want to convert these server reports to client reports. All of the Server reports uses Storeprocedures (or in some cases from the SQl Functions) All of them work properly… >>> More
iPhone - Open excel from SSRS 2008

as seen on Server Fault - Search for 'Server Fault'
We're currently having a problem with our 2008 SSRS server sending excel reports to users with iPhones. They get the email with no problems, but when the XLS file is opened on the phone, it returns an error of: Invalid format. Everyone else can open the report with no problems (email/blackberry) The… >>> More
SSRS 2008 Report Manager Error

as seen on Stack Overflow - Search for 'Stack Overflow'
I have just installed SQL Server 2008 including Reporting Services on Windows Server 2003. I'm having a problem though accessing the Report Manager. When the Reporting Service is first started I can access it fine but after maybe an hour when I try and access it I get an error saying: Unable to… >>> More
How to disable SSRS 2008 manager

as seen on Stack Overflow - Search for 'Stack Overflow'
Can you disable the SSRS 2008 manager (http://mydomain/reports), while leaving the report server working (http://mydomain/reportserver)? EDIT: Got it! This is how you do it in SSRS: Turn off Report Manager >>> More
Force SSRS 2008 to use SSRS 2005 CSV rendering

as seen on Stack Overflow - Search for 'Stack Overflow'
We are upgrading our report server from SSRS 2005 to SSRS 2008 R2. I have an issue with CSV export rendering for SSRS 2008 where the SUM of columns are appearing on the right side of the detail values in 2008 instead of the left side like in 2005 as shown in the below blocks. 117 and 131 are the sums… >>> More

Related posts about parameters

Application pool crashing regularly (8007006d) (Service Unavailable)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a basic web form site running. Nothing out of the ordinary. It is frequently crashing the application pool. The error code I got from the logs is '8007006d'. Googling this does not come up with the usual bevy of results.... I do get a few people with a similar problem. Any the advise seems… >>> More
bonding module parameters are not shown in /sys/module/bonding/parameters/

as seen on Server Fault - Search for 'Server Fault'
I have a server with Suse 11 sp1 kernel 2.6.32.54-0.3-default, with modinfo bonding i see all parameters, but under /sys/module/bonding/parameters/ not modinfo bonding | grep ^parm parm: max_bonds:Max number of bonded devices (int) parm: num_grat_arp:Number of gratuitous ARP packets… >>> More
Whats the difference between Command Parameters and Menu Contribution Parameters

as seen on Stack Overflow - Search for 'Stack Overflow'
I can see that parameters can be defined for Commands defined using the Commands extension point. I can not define a value for these command parameters. I can also define parameters under the Command element in the menus extension point when defining menu contributions. I can define a value for the… >>> More
Using template parameters as template parameters

as seen on Stack Overflow - Search for 'Stack Overflow'
Why is the following code invalid? template <typename S, typename T> struct B{ void f(T t, S s) {t.f<S>(s); } }; gcc 4.3.4 complains that it "expected primary-expression before '' token", i.e. that "S" wasn't a valid primary-expression. >>> More
How do you Send More that 20 Parameters to a Stored Procedure Using ODP.Net?

as seen on Stack Overflow - Search for 'Stack Overflow'
Switching from Microsofts Oracle Driver to ODP.NET version 10.2.0.100. After changing the data types to OracleDBTypes in a procedure, that worked perficetly using System.Data.OracleClient, the procedure fails if we try and pass in more that 20 parameters. The error returned is: ORA-06550: line… >>> More