+9
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.
Best answer by ChanakaAmarasekara
View original
+15
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
+9
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.
+15
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
+9
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.