DevExpress parameter null value

  • 16 August 2022
  • 5 replies
  • 59 views

Userlevel 3
Badge +11

I create a DevExpress report using a stored procedure. I have 2 parameters with the actual value NULL:

 

Somehow the report tries to execute the stored procedure with a value of -1 instead of NULL:

 

 I checked the NULL value allowed checkbox in DevExpress, so that should not be a problem I think. 

What am I doing wrong here?

 

SF 2022.1 ; DevExpress 1.40


This topic has been closed for comments

5 replies

Userlevel 7
Badge +11

Hi Hugo,

Have you set the Allow null value property of the report parameters?
 

 

Userlevel 3
Badge +11

Hi Jasper,

 

Yes, I did do that. I have worked my way around the situation by allowing a -1 value in the query, but it is not the right way of course.

Userlevel 3
Badge +11

These are the parameter values:

 

Userlevel 7
Badge +11

Hi Hugo,

I have created ticket #4604S to investigate this issue.

Userlevel 7
Badge +11

This issue is solved in the upcoming release of the Windows and Web GUI and the Indicium application tier.