Ian Stallings: web log - All Comments

re: SQL Server Reporting Services - Multi-Value Params - part 2

Brandon — Mon, 14 Jul 2008 16:13:55 GMT

Gabriel is right. The easiest way to do this is to have your stored procedure not do the filtering on the multi-valued parameter, and have Sql Server Reporting Service (SSRS) perform the filtering. (Note this only works if the stored procedure won't return too much data if it doesn't do the filtering.) Then you can create a filter in SSRS that looks like what Gabriel suggested.

You can add an SSRS filter by clicking on the Data tab in SSRS, click the ".." button by your dataset, which will open up a pop-up window. Click on the "Filters" tab on the right. Type in the information there.

re: SQL Server Reporting Services - No Multi-Value Params?

Choi Ng — Mon, 23 Jun 2008 18:58:17 GMT

Report Services 2005 let you provide multi-valur for your report parameter.

In your t-sql you should have

Select * from yr_table

WHERE (yr_parameter IN (@yr_parameter))

Reprot Services 2000 don't have the property to let you select the multi-value, but you create a stored procedure to work around

re: SQL Server Reporting Services - Multi-Value Params - part 2

Para — Mon, 12 May 2008 05:28:10 GMT

Hey this code was helpful, thanks.

But this seems to be working for me only if I have the exact code of the RDL in a Stored Procedure. If I add the exact code to the RDL it says too many arguments for the function dbo.StringToBigIntTable..... Do you have any clue as in why it says so? It just doesn't make any sense to me as to why the same code that works on the SP doesn't work on the RDL....

Cheers,

Para

re: SQL Server Reporting Services - Multi-Value Params - part 2

ryan — Mon, 05 May 2008 18:01:57 GMT

works for me, thanks for posting the code.

re: SQL Server Reporting Services - Multi-Value Params - part 2

kevin_cio — Tue, 08 Apr 2008 12:52:49 GMT

I agree - this feature should have been included COMPLETELY or removed COMPLETELY.

It is just another example of how code is required to make RS work properly.

(my own sarcasm: Do you think MS developers ever used Crystal Reports?)

re: More gumstix - WinCE Port (Drumstix)

garlic — Fri, 14 Mar 2008 02:33:44 GMT

! need a bootloader that’s capable of loading and running the Windows CE 5.0operating system image from a CF card. Can you help?

Mind Gravy » Blog Archive » links for 2008-02-07

Mind Gravy » Blog Archive » links for 2008-02-07 — Thu, 07 Feb 2008 12:28:51 GMT

Pingback from Mind Gravy » Blog Archive » links for 2008-02-07

re: Installing Windows Service Using .msi

Sohjiroz — Fri, 01 Feb 2008 17:11:27 GMT

Thanks Adam, is nice to count with people who wants to share good information, i own you one

re: SQL Server Reporting Services - Multi-Value Params - part 2

Gabriel — Thu, 17 Jan 2008 19:05:36 GMT

Ever tried this?

=split(join(Parameters!YourMultiValueParamter.Value, ","), ",")

Silly I know...

Lanyards Craft Plastic

Lanyards Craft Plastic — Mon, 14 Jan 2008 12:12:55 GMT

Many times, you will become overcome by the massive accumulation of Beaded Eyeglass Chain Lanyard stories handy.