displaying result in a bar

[janise]

Good afternoon gurus!
I have a tough requirement.
I am asked to use asp or write a sql server stored procedure that will accomplish two things.
One, to determine how many times an event has occured.
For instance, if I need to determine how many times an employee has signed up for a class, then I need to display the result in number as well as a graphical representation of the result... something like a pie chart or bar chart.
example will be:
if the class signed up by an employee is > than 5 then
display the employee who signed up for the class, the number of times signed up and then show the result in a pie or graph in one screen.
Is this even possible.
I have seen it done in excel but not with sql server or asp.
Your help is highly desired.
Thanks in advance.

 

[Tarwn]

This is possible. There are several components you can download out there that will do your bar charts for you (and a fairly complex one posted in the last few days by myself in this forum).
If you are using SQL Server as your database you will be able to select a count on the records that match the criteria (employee and class).
In order to be most helpful it would be good if you could tell us how much experience you have with ASP and SQL Server, I hate giving to simplistic or to complex advice :b
-Tarwn ------------ My Little Dictionary ---------
Extreme Programming - (1)Trying to code before my second cup of coffee. (2) While(1){ Ctrl+C; Ctrl+V; }
FAQ - Web-ese for "Forget Asking Questions, I am to busy"

 

[janise]

thanks Tarwn!
I am fluent with sql server querying and stored proc.
This is possible because my original database background is from oracle.
Asp, I can call myself beginner.
thanks again