Question

NVL in Business Reporter

  • 12 January 2021
  • 3 replies
  • 49 views

Badge +4

Hi All,

 

Is it possible to use NVL function in Advanced filter in Business reporter?  

I got a customer requirement to have the ‘Branch’ (code_b) parameter to 

Leave blank for all, select one or multiple in a BR report.

Do you have any suggestions to achieve this in BR?

 

what I tried is 

  • I defined ‘Branch’ as an optional parameter.

 

  • and used it in the Advanced filter as shown below.

 

  • it was giving the below error

     

Thank you!


3 replies

Userlevel 2
Badge +4

Hi Disnam,

Can you further explain what do you mean by ‘Leave blank for all, select one or multiple in a BR report.’?  Does that mean that the parameter value should be null when you want to select all the branches? 

Best Regards,

Nisansala

Badge +4

Hi Nisansala,

 

Yes, you understood correct. 

 

Thank you!

Disna.

 

Badge

Hi - I am also tring to figure  out how to do things the “SQL way”, and my first try would have been something like your example, or (DIM.CODE LIKE ‘&Param OR &Param IS NULL). Neither worked. I also tried to define fixed string parameter &pct with a value of % to  use in the NVL, but that didn’t help either.

 

It seems that the functions have to be used within a function parameter. Here I have used the standard input parameter Account and the NVL simple function to get the desired output:

 

 

 

 

Reply