[RESOLVED] Report with NULL parameter

[techgnome]

Null is not nothing
Nothing is not empty string
empty string is not null

NULL <> Nothing <> ""

Null != Nothing != ""

They are not the same thing.

I didn't say to pass in an empty string. I said you need to pass in a null value.

Valeue : =IIF(Parameters!ReportParameterAliasnaam.Value = "", Nothing, Parameters!ReportParameterAliasnaam.Value)

Still passing in Nothing...
Try using DBNull...


-tg