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.
Page 1 / 1
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
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.
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
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.