best way to create custom excel report c# from tables

Question

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

vivek kulkarni · Answer

Hi 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