in multivalue parameter

Last Post 19 Dec 2006 01:13 PM by petersr2. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
chandreshsoni
New Member
New Member

--
28 Jun 2006 10:32 PM
Hello SQL Reporting Service Experts

I have a report which accepts multi value - check box paramter, i remember when i was using SQL 2000 Reporting i use to automatically get the <Select ALL> options in that list on selecting all options gets selected. but when i am using SQL 2005 i dont get that option in the parameter list.

Any Idea how to achieve that in the report. as my drop down list is too big for any uders who wants to select all they have trouble selecting all values one by one

i appreciate your help on this.

regards
Soni
petersr2
New Member
New Member

--
19 Dec 2006 01:13 PM
Did you ever get a solution to this problem. I am having the same issue
nickd_SQL
New Member
New Member

--
26 Jan 2007 02:53 AM
If I understand you correctly you want an "all" option in a drop down parameter box
I do it like this if you are query the data do it like this
Select Code, description from Mytable
Union All
Select "ALL", '<All>'
Order by description
This will put <All> at the top of the list

Then in your select statement where clause

Where (CODE = @CODE or @CODE = 'ALL')




You are not authorized to post a reply.

Acceptable Use Policy