Multivalue (ALL) ,SQL 2005 Reporting Services

Question

Post reply

Multivalue (ALL) ,SQL 2005 Reporting Services

Syed Imam

Newbie

Points: 3
More actions
June 22, 2006 at 10:54 am

#153050

Hi
Iam using this query to use ALL (Multivalue)function, It works well if
the varaiable is Character(varchar) but it doesn't work if the variable
is integer (smallint), Do you know , how to slove this problem.
1)   ..........AND ( Field IN (@Parameter) or 'ALL' IN (@Parameter))

2) Select 'All' as ID , 'All' as Label

     Union
     Select name as ID, name as Label from ProductCategory

I really appreciated it.

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

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

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

Wouldn't this work?

.....AND (field in (@parameter) or @parameter like '%All%' )

?

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Syed Imam Newbie Points: 3 More actions · Answer 2

Jason,

It works but when I use this query for new dataset.

2) Select 'All' as ID , 'All' as Label

Union

Select name as ID, name as Label from ProductCategory

Gives me a error message .

I know Iam pushing the envople, actually I am new in SQL enironment, just started my carrier.

Thanx for helping.

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 3

What are the datatypes of your fields (ID and name)?

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Syed Imam Newbie Points: 3 More actions · Answer 4

Thanx Jason, Iam able to solve my problem.

I have one more problem, actually Iam trying to have selected Criteria at the top. right now its giving me only one selected criteria, even if I select two City from drop down list.

Iam using this query.

="Filtered by: "+Parameters!City.Value(0)

Thanx again for helping me.

Syed

Mike Kendall SSC Eights! Points: 958 More actions · Answer 5

Syed,

This from MS Books on Line.

=Join(Parameters!Title.Value, ", "))

Provides a comma delimeted list of the selected values. You could also use .Label if the values aren't user friendly.

Mike