sql server reporting services: Multi Value Parameter and Filtering -- sql server reporting services

Multi Value Parameter and Filtering

Are friends electric?
11/10/2006 8:34:02 AM

sql server reporting services:

Hi All

I am trying to filter a table on my report based on a multi-value parameter,

I have tried several methods to no avail. When I use the following I do not
get an error but I do not get data showing on the report.

Expression is set to =Fields!Account.Value
Operator is set to In
Value is set to =join(Parameters!Select_Individual_Account.Value, ",")

Can anyone help this newbie style question

Regards

RE: Multi Value Parameter and Filtering

Matt M
11/10/2006 9:10:01 AM

I think you should be able to leave out the Join function.

Set the value as: =Parameters!Select_Individual_Account.Value

I do that in one of my reports and it works fine. Just make sure there is
not a (0) at the end of the paramerter.

[quoted text, click to view]

RE: Multi Value Parameter and Filtering

Are friends electric?
11/10/2006 9:46:02 AM

Thanks for helping Matt

I now get the following error

The filter expression for the table cannot be performed,
cannot compare data of type system.string and system.object

any ideas

Thanks

Steve

[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.