How can I force report parameter to accept a null value. I tried using the check box for null values to no avail. I am creating a custom code to get around this problem. I used the simple IIf statement below:
=IIF (Parameters!MarketID.Value = "None", IsDBNull.Value, Parameters!MarketID.Value)
...I was getting an error message like this:
The value expression for the report parameter ‘MarketID’ contains an error: [BC30455] Argument not specified for parameter 'value' of 'Public Shared Function IsDBNull(value As Object) As Boolean'.
How can I frame the IIf statement?
Thx in advance
You could try replacing IsDBNull.Value with System.DBNull.Value
No comments:
Post a Comment