Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying only if 1 or more of 3 flags has True results 1

Status
Not open for further replies.

MCuthill

Technical User
Jul 19, 2006
669
CA
BigDaddyE,

Just a quick idea... what about having the default value of StringVar message being "No" instead of ""?
(if you still need empty space for the "No"s, you could conditionally supress the "No"s)

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
 
Your first step is to determine which field is causing the null--or do you just mean that the message = ""?

Once you have fixed the null field issue, I would just set these up as three formulas that return 1, like this:

If IsNull({episode.dschg_date}) and
{pat_hosp_stay.dschg_date} >= {episode.soc_date}-7 Then
1

Then set up a fourth formula to use for section suppression:

{@flag1}+{@flag2}+{flag3} = 0


-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top