Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ZMike
Posting Yak Master
110 Posts |
 Posted - 2009-04-16 : 09:40:56
|
| Good Morning,I have a report Parameter question. I'm using a Multi Select for a String field (Multi-value is selected)I have "Allow Blank Value" SelectedI'm using a data set for available valuesfor defualt values I need to have a value for blankI've selected <Blank> manually typed it in but I've been un-successful on making it as a defualt. Once you get to the view you can select the blank field but I cannot make it default to that. Is there a trick to it ?Thanks |
|
|
shekhar
Starting Member
3 Posts |
Posted - 2009-04-18 : 08:39:07
|
| Mike,As don't have 2005, I tried it in SQL Server 2008 and it worked.Add a dummy row to the dataset parameter as belowselect col1, col2, col3,.... from mytableunionselect '<Balnk>','','',....Now set this parameter to <Blank> Manually type it. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-18 : 15:10:17
|
quote:
Originally posted by ZMike
Good Morning,I have a report Parameter question. I'm using a Multi Select for a String field (Multi-value is selected)I have "Allow Blank Value" SelectedI'm using a data set for available valuesfor defualt values I need to have a value for blankI've selected <Blank> manually typed it in but I've been un-successful on making it as a defualt. Once you get to the view you can select the blank field but I cannot make it default to that. Is there a trick to it ?Thanks
just give default as "" in parameter tab |
|
|
|
|
|
|
Report Parameters Question