reporting services - SQL Parameters, How to give * (ALL) a default parameter? -


i have query:

 select job,age,name + + surname fullname 

now filtering (in ssrs) per full name. how set default value in full name drop down field show candidates default?

drop down field looks follows:

everyone jon patric kelly steve 

you can pullback data similiar query below:

select * (  select orderby=2,filtervalue=surname, job,age,name + + surname fullname  union  select orderby=1,filtervalue=null, null,null,null + + '<all>' fullname ) order     orderby,fullname 

then send in filtervalue filter clause similiar to:

select * mytable     (@filtervalue null) or (surname = @filtervalue)  

Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -