Hello,

I have a XML query based DataSet, and i need to set multi-value parameter default value with this DataSet.

In some cases DataSet return null rows, and thus cause an error in report because multi-value parameter cant set to null value. I have to filter my main dataset using this multi-value parameter value.

Since my dataset is in XML, i cant handle null value return the way we normally use in SQL.

How can i set my multi-value parameter (0) index value to blank or anything other than null?

I have tried to use VB code in default value expresson that can check count of this multi-value parameter, and if found 0 set Parameter(0) = "Blank". but when running report i am getting error message The DefaultValue expression for the report parameter contains an error: The expression references the parameter, which does not exist in the parameters collection. Letter in the name of parameter must use the correct case.

any help would be appreciated.