supressing Section

venu muddasani
venu muddasani used Ask the Experts™
on
I am inserting sub report into the main report, sub report group footer and report footer and I am displaying and suppressing sections on the conditions of different event types, the problem is when the field is blank it displaying both the sections group footer and report footer.
What I need to do is: if field is blank suppress the sections other wise it has to evaluate event type conditions and according to that suppress or display the sections.
Thank you
Venu
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Check for IsNull()

Try

If IsNull({YorField}) then
   TRUE
Else  Evaluate the other conditions

If it truly is blank

If {YourField} = "" then
    TRUE
Else  Evaluate the other conditions

mlmcc

Author

Commented:
Exactly worked solution, Thank you very much.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial