How do I create a report with an Excel front end and SQL server back end?
Posted on 2004-04-20
I've been looking but can't find the best way to do this.
The ideal situation would be an Excel file with a SQL Server database.
The data is coming from different tables within one database. Various calculations have to be done to the data based on information in these tables.
The end user should be able to just click a button on a web page and download a copy of the report/spreadsheet.
The data is updated everyday, and the spreadsheet should update automatically. For example, todays report would include days in April from the 1st to yesterday, the 19th. Tomorrow's report should include data from the 1st through the 20th.
Can someone point me in the best direction for accomplishing this?
BTW, my background is with ASP and SQL Server.