best way to create custom excel report c# from tables
i have to create a custom excel report from multiple table of database. please let me know which is best way to create custom excel report from multiple datatables in c#.i am new to report making
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
vivek kulkarniPosted Nov 8, 2013, 5:16 AM
I would suggest using SSIS or SSRS.
Using SSIS you can generate the desired report or SSRS can be used to generate then with the export facility you can export the report as excel/pdf.
here are few links.
http://www.mssqltips.com/sqlservertutorial/207/creating-a-simple-ssis-package/
http://www.codeproject.com/Articles/13725/Getting-started-with-SQL-Server-Reporting-Services
http://www.codeproject.com/Articles/621332/Building-Your-First-SSRS-Report
https://www.microsoft.com/en-us/sqlserver/solutions-technologies/business-intelligence/reporting.aspx