Null ParameterValue

Ok, seems like this should be a quick and easy one, but I can't find any info anywhere. How do I pass a ParameterValue to the Render method that represents a Null parameter?

Is this enough?

ParameterValue[] parameters = new ParameterValue[1];
ParameterValue nullParam = new ParameterValue();
nullParam.Name = "SomeParam";
nullParam.Value = "NULL";
parameters[0] = nullParam;

..
then set up everything else we need to call ReportingServices.Render...

Thanks
Scott

When you send "null" parameter value as url link to report server it looks like this:

http://reportserver/?%2fReport1Test&param1%3aisnull=True&rs%3aParameterLanguage=&rc%3aParameters=Collapsed

"param1" is the name of null valued parameter.

Hope this will help you somehow

Maciej

|||

Use this

nullParam.Value = System.DBNull.Value;

|||I'll try that, thank you. For the moment, sending the parameter values in with no value set (i.e. the string value property is null) seems to be working, though it could be related to the fact that the parameters have null values as a default, I will try what you suggest on my next report and post back the results here.|||I tried the System.DBNull.Value and I was getting an error because it was expecting a string. I passed String.Empty and that did the trick.