CODEWITHSUNDEEP
crystal-reportscrystal-reports-formulas
Marc Anderson
Marc Anderson

Reputation: 21

Crystal Reports Section Suppression not working

I have a report that is counting a specific event with a running total. In the group footer, I want to suppress the footer if the count is not a specific value (RTotal0 <> 5) AND if the most recent occurrence of the event is not within the last seven days (datediff("d", EventDate, Currentdate) >7).

Either of these conditions works by themselves, but if I combine using an "AND" statement, only the datediff condition is evaluated; the RTotal condition is ignored. Any ideas? Here's my suppression formula:

{#RTotal0}<>5 and  DateDiff ("d",{EVENT-DATE},CurrentDate) >7

Thanks

Upvotes: 1

Views: 149

Answers (1)

Marc Anderson
Marc Anderson

Reputation: 21

Found this format finally worked:

not ({#RTotal0}=5 and DateDiff ("d",{EVENT-DATE},CurrentDate) <8 )

Upvotes: 1

Related Questions