default value for text parameter defined as string

ReportServer (EN)
1

Hi,
I would like to know why does reportserver set a blank value if the text parameter, defined as a java string, is left empty instead of null value?

Another question is : How can I force reportserver by sending null value if the string parameter is left empty?

Thanks,

Cheers,

Alex

2

Hi,

I am afraid there is currently no easy way of doing this. The default is that for a text parameter that is a string an empty string is forwarded as an empty string rather than NULL. While for other datatypes (e.g., Integers) an empty string is NULL. You could hack ReportServer here and, for example, adapt parameters on report execution, but there is no clean way of doing this. The best way would probably to have this configurable in the parameter settings.

Cheers
Arno

3

About the Integer, I have been noticing that I cannot leave an empty value, if the text parameter is an integer data type.
As soon as I ve been trying to run the preview, reportserves shows up a red symbol, like a warning, because it wants a value.
Since we have reports with text parameter , as integer, but they can be empty before running. How can I workaround this?
Thanks again,
Cheers,
Alex

4

Hi ralex,

for completeness:
we added an option for text parameters: “return null on empty” (RS-1953). This will be available in reportserver 3.0.6, available by the end of the year.

For integers and other data types, we return null if they are left empty. Only if the “mandatory” option is set, the user gets an error if the parameter value is empty.

Regards,
Eduardo

5

Hi ralex,

ReportServer 3.0.6 is released and this is available now as you can read in the release notes: https://reportserver.net/releasenotes/RS3.0.6.html

RS-1953 New Feature Extend text parameters to allow for NULL return on empty strings

Regards,
Eduardo