1. Create a Report Rule with condition Expression 1 [#Email] (variable email) equals NULL (= '')
2. Print the report and ensure the email field is blank
3. Report Rule says FALSE
Have anyone ever come across this.
Solved
Report Rule using validation on NULL for Variable is not working
+9Best answer by ChanakaAmarasekara
Hi,
As both expression1 and expression2 needs values you can give null there. You will have to do a SQL validation using nvl() or you can write your own sql logic in a method an call that. If it's only null you can do it as in the attached picture.
Expression1 > [&SELECT nvl('[#Email]', 'true') FROM dual]
Operator =
Expression2 > true
Regards,
Chanaka
This topic has been closed for comments
+15Hi
It’s not clear on how you have configured the rule.
Can you add a screenshot of the report rule, the condition and actions you have configured. Would be helpful if you export and rule and add that too.
Regards,
Chanaka
- Chanaka Am -
1 person likes this
+9ChanakaAmarasekara wrote:
Hi
It’s not clear on how you have configured the rule.
Can you add a screenshot of the report rule, the condition and actions you have configured. Would be helpful if you export and rule and add that too.
Regards,
Chanaka
Kind Regards,
/Chathura.
+15Hi,
As both expression1 and expression2 needs values you can give null there. You will have to do a SQL validation using nvl() or you can write your own sql logic in a method an call that. If it's only null you can do it as in the attached picture.
Expression1 > [&SELECT nvl('[#Email]', 'true') FROM dual]
Operator =
Expression2 > true
Regards,
Chanaka
- Chanaka Am -
+9ChanakaAmarasekara wrote:
Hi,
As both expression1 and expression2 needs values you can give null there. You will have to do a SQL validation using nvl() or you can write your own sql logic in a method an call that. If it's only null you can do it as in the attached picture.
Expression1 > [&SELECT nvl('[#Email]', 'true') FROM dual]
Operator =
Expression2 > true
Regards,
Chanaka
Thank you very much.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.