Unable to use "Allow null value" on report builder 15.x version

Abdelmajid — Tue, 18 Jan 2022 17:19:13 GMT

Hello,

We are encountering issue after report builder upgrade from 14.x to 15.x version, where rdl files using parameters with "allow null value" setting isn't working as expected anymore.

We are unable to run the reports and get the following error message expecting a value to be entered.

Not sure if the way this function works has changed after upgrade, appreciate any help on this!

Thank you!

Re: Unable to use "Allow null value" on report builder 15.x version

Anonymous — Fri, 21 Jan 2022 06:39:52 GMT

Hi Abdelmajid ,

According to the error message you provided:

The EXECUTE command for a parameterized SQL stmt specifies a list of parameters. The number of parameters in that list must equal the number of parameters that appear within the SQL statement.

Please correct the SQL statement and resubmit.

If I have not understood your needs correctly, please do not hesitate to inform me.

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

topic Unable to use "Allow null value" on report builder 15.x version in Report Server

Unable to use "Allow null value" on report builder 15.x version

Re: Unable to use "Allow null value" on report builder 15.x version