Multiple filter options in SSRS

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Raj's Ten Centuries Points: 1044 More actions · Answer 1

I know this might not fulfill your requriement, you could just Insert table. in Column Expression enter parameter.<parameter Name>.Value

Hope this helps 🙂

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 2

hi

I'll surely try.

But when executing in BIDS the report shows relative error of syntax and not when deployed.

Raunak J

veeren4urs SSCrazy Points: 2763 More actions · Answer 3

Hi all,

I have report which contains a Business group listing.

I need to have a logic where in the user will select the number of filter fields and only those fileds checked will be displayed.

>>>> I think u can do this by using multiselect option i nthe report parameter.

When I choose Select All..every other item in the dropdown parameter list is preceeded by a comma

>>>u can do this by using the below code.

=join(parameter!test.value,",")

i hope it will work..

A vague idea might be that when the respective fields are checked an array of parameters is generated and is passed to underlying query.

Can you help me on this issue.

Thanks.

veeren.

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 4

it's done...changed the query and used IN function with allow multiple values in parameter options

Raunak J