Parameters Handle NULL VALUES

[Former Member]

Hello Developers,

I have some parameters that is of type Number. I want to pass NULL into it but we can only pass NULL values to the parameter which is of type String.

The parameters are coming from BE and I cannot change it. I tried to create a sub-report and use a formula to handle it. But couldn't figure it out.

Thanks,

Preethi.

[former_member205840]

Hi Preethi,

First of all will that BE prompt allow you to pass NULL value ?

You can create a sub report with a formula or a string type parameter (optional) which can accept NULL value. But you can't join / link this with sub report parameter.

Best way is to mask that parameter like :

Create a blank report -- Insert Main report as sub report--

Now in blank report create a formula with numeric value with 0 (zero) and pass this to BE parameter.

Crate a string parameter at sub report (Main report earlier) and make it optional.  This parameter can be compared with your database fields and can pass NULLs.

Thanks,

Sastry

[abhilash_kumar]

Hi Preethi,

Make the prompt optional and use the HasValue() function along with it.

-Abhilash