Hello everyone I am new to Crystal Reports and seem to have been thrown to the wolves here at work.

I work for a police department in Florida, I have a database that collects GUN SHOT information that is recorded throughout the city. What I have been asked to do is create a report that shows all the gunfire activity we have had in the last 24 hours and have it emailed to the brass at 8 AM everyday.

The second part and I believe more challenging part is to provide email notification every time there is a gunshot. I had an idea of how to do this but do not know if it is feasible.

I was thinking I could run a query every 60 secs to generate a report. this would only show a report for 60 secs. Then I could email that report out. However every time the report is blank an email would be sent to and I do not want that.

I am a novice at Crystal Reports and we are not looking to hire an outside vendor to complete this.

So I hope you guys can help or I will be spending a lot of time  and money at Barnes and Nobles.

Thanks

Matt