Reports, charts etc.

The front end for this project has been developed in Codecharge Studio and it is my preference to continue down this track. I need to develop some reports to display the data to clients. When a client logs on, then he can view his own data but data belonging to other users can be viewed but the other users must remain anonymous to the current user. I can clarify this later. The initial project is to display summaries of incidents, number of incidents and days lost etc. over a specified time period. I have access to a database and webserver, however, within one month, I will also have my own system and this project will also involve transferring the files etc. to the new system with minimal downtime. This report project will make extensive use of stored procedures and views so experience in this area is a must