Dataset Filter with Null Passed By Parm

[BB45]

SQL 2008 RB using models
SQL 2005 DB no direct db access

I have a report that has 2 datasets. Dataset2 populates a parameter list with a extra value (Select Null, ALL) and the ALL is the default.

Dataset 1 is the main data and this is where i have the problem. I am trying to set the filter for the dataset to accept the null and thereby not filter the data.

I have this expression in the dataset1 filter but I cannot figure out what to put for the second condition: =IIF(IsNothing(Parm.Value), ????,Parm.Value)

Thanks
BB

 

[RiverGuy]

Try an empty string:

=IIF(IsNothing(Parm.Value), "",Parm.Value

 

[BB45]

This does not work because my parameter is passing an integer.

 

[BB45]

Figured it out. The format works this way:

IIF(IsNothing(Parm.Value),Fields.Value,Parm.Value)