Hi All, Can anyone please show an example of using NVL2 function parameter in a BR report? I tried to use NVL but could not get what I wanted. And trying to use NVL2 function parameter, but not sure what should I enter for the first argument (ValueIfNull). please see the image.&CodeB is a standard parameter for DIM_CODE_B.CODEThe requirement is to get all CodeB values including NULL when the &CodeB leaves blank and the selected CodeB values when &CodeB has a value.Example:when &CodeB = say '45' , the report will only show the records with code_b = 45when &CodeB leaves blank (NULL) then the report will show the records where the code_b of any value plus the code_b IS NULL Thank you!
Showing this error when I going to generate a business report . what type of error it is? how can I solve it ? please suggest me.Thanks in advance.Saiful.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.