sql server reporting services: How do I use a comma separated parameters list -- sql server reporting services

Re: How do I use a comma separated parameters list

DragonVic
2/1/2006 7:51:35 AM

When I looked for the version I got this...

Microsoft SQL Server Report Designer
Version 8.00.1038.00

Is that still 2000? does RS 2005 come whith SQL2005? and VS.Net 2005?

[quoted text, click to view]

Re: How do I use a comma separated parameters list

Dan
2/1/2006 8:49:25 AM

I think that's still the version that comes with SQL Server 2000. (We
have 2005 and our version is 9.00.1399.00) You need a licensed copy of
SQL Server 2005 in order to get the Reporting Services version that
supports multi-select parameters.

When you install the client tools for SQL 2005, you get a "light"
version of Visual Studio 2005 for use with Reporting Services, Analysis
Services, and Integration Services. This is called Business
Intelligence Development Studio.

Re: How do I use a comma separated parameters list

Oleg Yevteyev
2/1/2006 9:31:38 AM

Switch to the generic query designer and change the query text to the
following
="SELECT * FROM USERS WHERE ID IN("+Parameters!ID_LIST.Value+")"
Hope this helps.

--------------------
Oleg Yevteyev,
San Diego, CA
It is OK to contact me with a contracting opportunity.
"myfirstname"001atgmaildotcom.
Replace "myfirstname" with Oleg.
--------------------

[quoted text, click to view]

Re: How do I use a comma separated parameters list

DragonVic
2/1/2006 11:05:20 AM

It probaly will work, the problem is I have dozens of lines in the script,
since the generic query designer doesn't work well with carriage returns, it
might take a while to join all into one. Thanks for the input.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.