Skip to main content

DevExpress parameter null value

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

Did this topic help you find an answer to your question?
This topic has been closed for replies.

5 replies

Jasper
Superhero
  • JasperSuperhero
  • 678 replies
  • 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
  • Hugo NienhuisSuperhero
  • Author
  • Superhero
  • 137 replies
  • 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
  • Hugo NienhuisSuperhero
  • Author
  • Superhero
  • 137 replies
  • August 17, 2022

These are the parameter values:

 

Jasper
Superhero
  • JasperSuperhero
  • 678 replies
  • August 17, 2022

Hi Hugo,

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

Hugo Nienhuis
1 person likes this
  • Hugo Nienhuis
    Hugo Nienhuis
Jasper
Superhero
  • JasperSuperhero
  • 678 replies
  • August 18, 2022

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

H
Hugo Nienhuis
2 people like this
  • H
    Henk-Jan van Laar
  • Hugo Nienhuis
    Hugo Nienhuis
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings