Suppressing Chart - suppressing according to formula not working

[cscarb]

Hi,
Crystal 2008
Right click the chart>Format CHart>Common tab> Suppress.
Suppress box is unchecked and I use a formula instead.

{sf_account.enrollment_completed} < date(2010,05,01)
or {sf_account.enrollment_completed} > date(2011,03,21)
or {sf_account.proactive_hd_upgrade_date} > date(2011,3,21)
or {practicegroup.name}="ZYY"

Unfortunately, the ZYY practicegroup is still showing the chart.
It only removes it if this is the FIRST in my list of requirements.
Anyone?
Thanks much,
Cscarb

 

[MCuthill]

cscarb,

I beleive you should use the Logical "AND" versus the Logical "OR" for this formula.

{sf_account.enrollment_completed} < date(2010,05,01)
AND {sf_account.enrollment_completed} > date(2011,03,21) 
AND {sf_account.proactive_hd_upgrade_date} > date(2011,3,21) 
AND {practicegroup.name}="ZYY"

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."

 

[cscarb]

I tried this already and it didn't work, but it is ANY one of those criteria that should suppress the chart, thus the OR.

Thank you for your quick response...

 

[lbass]

I think you are hitting a null value for one of the fields in your formula, so you need to expressly say what you want to happen if one of those values is null--and I'm not sure what that is, but one guess would be:

isnull({sf_account.enrollment_completed}) or
{sf_account.enrollment_completed} < date(2010,05,01) or
{sf_account.enrollment_completed} > date(2011,03,21) or
(
not isnull({sf_account.proactive_hd_upgrade_date}) and
{sf_account.proactive_hd_upgrade_date} > date(2011,3,21)
) or
(
not isnull({practicegroup.name}) and
{practicegroup.name}="ZYY"
)

-LB

 

[cscarb]

I think that was it!! Thank you so much, this has been extrememly helpful.
Regards
Candace