Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ind_tamu
Starting Member
3 Posts |
 Posted - 2008-08-21 : 17:10:50
|
| Hi I need to generate cumulative revenue report for everymonth along with bar graphs. How can i do it in sql server...I have data, actually i must provide asp.net interface 2 the user to enter data into DB.Which I am working now..Please help me..thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ind_tamu
Starting Member
3 Posts |
Posted - 2008-08-21 : 17:49:34
|
| Ok here is the info....Each and every month some employees submit their report to the HR.So each person has his Fname, Lname, description of his report, date it has started, is it still open, etc. Let us say in APRIL persons A,B,C,D..submitted reports. Again in May they submit some reports ..that way Here you go..!Calculate cumulative of All persons....(No individual)Draw a chart which is BAR chart...for each year(Chart should show Jan, feb,march,....dec) at the end of the month when we refresh cumulative report should be generated...plus a bargraph should be drawn.Actually I have plan to start a program using asp.net in C# and SQL server. Will that work? can I use reporting in sql server tools for this? help me....Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ind_tamu
Starting Member
3 Posts |
Posted - 2008-08-21 : 18:20:47
|
| Hi TaraThanx for replying in notime.To be honest I have a server here which is windows 2000 server. I dont know if i could install reporting services. And the report /graphs should be edited by many ppl in otherwords shud be shared by many people. so u think sharepoint will work to share??? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-21 : 19:26:00
|
| Install Reporting services with IIS and Asp.net. And you can use Reporting server securities to handle reports and subscriptions |
|
|
|
|
|
|
|
|
Cumulative monthly