Configure Crystal Reports 11 to Run Report When Condition Is Met?

Question

Hey all,

I have a requirement to generate a report for a client, but only when a certain condition is met. In this case, it's when employees hit their 15 or 20 year mark of service. Obviously, this isn't something that occurs every day and so the HR staff would like this report only sent to them when this does occur and not receive a blank report every day.

Any idea how to configure a report to only run or only get delivered when the data meets a certain criterion?

Thanks, Sonny

Answer 1

I recommend checking your criteria before you even get to the crystal report file. Personally, I would make an Access database that:

1. gets the data
2. checks your criteria
3. If criteria is met, run & email the report (either with a shell command or via the Crystal APIs).