In order to schedule a Crystal Report (CRS), you have to also have either Crystal Reports Server or one of the SAP BusinessObjects (BOE) packages. That's where the scheduling functionality resides. CRS is significantly less expensive than BOE and I think it will probably meet your needs.
The scheduler itself can't look into your database to determine when to run a report. However, you could use Event based scheduling to do something like this:
1. Create a job in the database that will run daily to determine whether any accounts are calling more frequently. At a minimum, this job has to create a blank file with a specific filename in a specific folder on the server where CRS is installed if the condition is met. I suggest that you also have it create records in a new table that include the information that you want to have appear on the report.
2. Create a report that reads the table created in step 1. Publish the report to CRS.
3. In the Central Management Console (CMC) for CRS, create a File Event that looks for the file that's created by the job in step 1.
4. Schedule the report created in step 2 to run shortly after the job finishes in SQL server, based on the File Event that you just created.
5. On the server where CRS is installed, create a .bat file that will delete the file. Use the Windows scheduler on the server to run the .bat file daily at some point well after the job and the report schedule are complete. This is a VERY IMPORTANT step - the file has to be missing from the folder for a period of time in order for the Event Server in CRS to identify its appearance as an event.
-Dell
IP Logged
