Skip to main content

DevExpress parameter null value

  • August 16, 2022
  • 5 replies
  • 78 views

Hugo Nienhuis
Superhero
Forum|alt.badge.img+12

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 replies.

5 replies

Jasper
Superhero
  • August 17, 2022

Hi Hugo,

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

 


Hugo Nienhuis
Superhero
Forum|alt.badge.img+12
  • Author
  • Superhero
  • August 17, 2022

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.


Hugo Nienhuis
Superhero
Forum|alt.badge.img+12
  • Author
  • Superhero
  • August 17, 2022

These are the parameter values:

 


Jasper
Superhero
  • August 17, 2022

Hi Hugo,

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


Jasper
Superhero
  • August 18, 2022

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