How would you approach this project

[PhaZe]

I'm interning for a team right now and my current project is to try to find a way make my teams quarterly meetings power point more "real time".

What I mean is that someone usually prepares the power point a week or two in advance using data from excel sheets (which are exporting from a sql server 2005 database), so the data is a week or two old during the meeting.

The power point is about 60 slides long and is basically a summary of what went since the last meeting. There are a lot of graphs, statistics, and other crap.

They would like to be able to view graphs and stats with information directly from the database, that is easily and quickly accessible. (ie. a web site)

At this point, I am trying to figure out how to create graphs using asp.net and c# using data from their sql database.

I figured if I make graphs similar to the ones that they make in their powerpoint, it will be familiar to them when they see it in web page format.

any ideas or suggestions would be welcome.

thanks.

 

[joutlaw]

Do you have access to Crystal Reports?

You could create a project that calls the crystal reports that link back to the live data on the tables. The graphing is already built into to crystal... basically it would just need to know your queries or tables to get the data from.

 

[PhaZe]

I am using Visual Studio 2005 and under Crystal Reports I have CrystalReportView, PartsView, and Report Source.

Is that all I need?

edit: I guess I would need the actual crystal reports application huh. I don't think we have it here

 

[imported_Dhaval00]

Since you're using SQL Server 2005, you also have access to Reporting Services.

Look at www.gotreportviewer.com for samples on how to accomplish some of these things you pointed out to earlier. You'll want to understand the pros and cons of local and remote reports.

If you installed the SSRS samples, you can see some of the builtin samples under localhost/reports/Pages/Folder.aspx.