How to set null for integer (or string) parameter?

[Istvan Piroska]

Hello,

I would like to retrieve data from stored procedure into a rdl report.

The stored procedure has integer parameters. Running it from the SSMS is working well without specifying the parameters.

How can I achieve the same functionality in the Report Designer?

Without selecting parameter the following error comes up: "Select a value for the parameter 'ProductType'."

The parameter is working well if it's selected. I checked the "Allow null value" option. Although I could read in the docs that it is not enough. I have to set the null value explicitly as a value, but it's not possible for integer. I also tried switching to string, which would be fine as well, but it didn't work either.

How can I make it work?

[Muthuramana Sankaranarayanan]

Hi Istvan, 

Please find the details for your queries from below, 

Without selecting parameter the following error comes up: "Select a value for the parameter 'ProductType'."	When a parameter is allowed to have null or blank values the report will be allowed to be previewed without passing any parameters or else the reported error will be thrown which is a behavior.
I checked the "Allow null value" option. Although I could read in the docs that it is not enough. I have to set the null value explicitly as a value, but it's not possible for integer. I also tried switching to string, which would be fine as well, but it didn't work either.	We checked the reported issue but we were not able to reproduce it. Is it possible for you to share a simple report with issue reproducible as it will be helpful for us to validate the reported issue form our end.

 

Also for further details regarding the properties “Allow blank values” and “Allow null values” in parameter we suggest you to refer the below documetnation link, 

 

https://help.boldreports.com/on-premise/report-designer/report-parameters/add/ 

 

Regards, 

Muthu Ramana S 

[Istvan Piroska]

Hello Muthu,

Thanks for the answer.

Actually I am pretty sure that the missing null value element cause the problem.
Following the documentation:

"Select Allow null value, if the value of the parameter needs to be set as null.
Note: If you specify valid values for a parameter, and you want null to be one of the valid values, you must include null as one of the values that you specify. Selecting this option does not automatically include the null value for available values."

It's fine, but how can I get a null value, what is the "best practice"? The values are set in query directly from the database. This part is working fine. But I wouldn't like to place a null value in the database. Is there any way to add it somehow manually?
(Just to compare, in a C# vievmodel I can manage it of course, but here this is not the case).

This is my actual notes about the issue.
If there is no solution can I send the project somehow in privat?

[Istvan Piroska]

Yes, it was the issue.

Meanwhile I could solve to pass an extra null object to the data source and it is working perfectly now.

The solutions is in an old but very good video:

https://www.youtube.com/watch?v=h6WJ4ToBJ8g

[Muthuramana Sankaranarayanan]

Hi Istvan, 

We are glad the issue is resolved at your end. Please let us know if you need any other assistance regarding this. 

 

Regards, 

Muthu Ramana S