If you have Crystal Reports you can create a report to show those statistics, then automate the report in a pie graph to export to HTML. I currently do this with open/closed by staff, open/closed by department and so on. I then automate the report to update every hour and generate the html to a folder on my web server. My staff and management can then click on the Reports link in the staff panel to see the html reports.

Hi, can u show how to do it using Crystal Reports. Appreciate the help. Thanks.