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

[Abdelmajid]

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! 

[v-xiaoyan-msft · Accepted solution]

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.