Suppressing Details

[rich32]

I'm trying to suppress the details area in my report using two criteria

do {applicant_id} = Next({applicant_id})while
(DateDiff ("d",cdate({@StartDate}) , CurrentDate) > 30)

I have also tried
{applicant_id} = Next({applicant_id})and
(DateDiff ("d",cdate({@StartDate}) , CurrentDate) > 30);

It will only take one criteria not both.

 

[synapsevampire]

Try:

{applicant_id} = Next({applicant_id})and
currentdate-{@StartDate} > 30

This will suppress rows where the next applicant_id is the same, and the @startdate is more than 30 days old.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[rich32]

Thank you, unfortunately the "and" did not work. I used "or" it worked fine.