I need an Excel report application written in Asp.Net with C# or VB.Net. I will give my SQL server database script with data.
1) Don't create excel object in web server. I don't have MS Excel on my production server
2) Don't want to go for paid third party software, you may use free third party software.
3) Either you can display the output excel file in browser or allow user to save the excel file.I would prefer the first one.
4) Output excel files need formatting, Auto fit, Cell Merge, Printing
5) User should be able to do the Financial calculations/Conditional formatting and Filters with the output excel file.
6) Need good Coding/Architecture, so send me some technical/approach document with some sample code.
7) Right now Six reports needs to be developed.
8) You should have some stored proc knowledge.
Please simply don't say "I can do". Serious bidders only.
Already I have this application in VB and i will give the source code to selected providers to understand/implement the logics.