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 |
|
powerwind
Starting Member
1 Post |
 Posted - 2010-07-02 : 06:11:24
|
Hi :)Does anyone know how to make a dropdown parameter optional, with the "null" checkbox next to it? In the param properties it's checked "allow null value" and "allow blank value", and it doesn't work it's still madatory to select a field to run te report. In the stored procedure, the parameter is =null, and in the WHERE part i've tried with (p.SomeName = @parameter OR @parameter IS NULL),and with the p.SomeName=COALESCE (@parameter,p.SomeName), still nothing, i even tried with expression in the default value =Iif(Parameters!SomeName.Value is Nothing,Nothing,Parameters!SomeName.Value) but it raises an error stating that the expression that refernces parameter does not exist in the parameters collection, and dataset and report parameter are correctly mapped.Appreciate any help  |
|
|
|
|
|
optional dropdown parameters