The application I've been working with need to have a feature where multiple reports exported to excel as worksheets and NOT datagrids need to be merged into one workbook.
So far I had been able to merge them as datagrids but this is not what the client needs. Any lines of codes that I need to incorporate in order to accomplish this export? DLLs that I might need but don't have? 3rd party tool that would help me to get these worksheets as one workbook? ActiveReports and Infragistics have been used.
Thx!
Hello Ron,
Thank you for your post!
Currently the Export method of the XamReportViewer takes a Stream and the rendering format for the exported report: http://help.infragistics.com/Help/Doc/Reporting/2014.2/CLR4.0/html/InfragisticsSL5.Controls.Reports.v14.2~Infragistics.Controls.Reports.XamReportViewer~Export.html.
Having in mind the status of the Reporting product (http://ko.infragistics.com/community/blogs/jason_beres/archive/2015/04/13/product-status-change-notification-infragistics-reporting.aspx), I would suggest using our XamDataGrid and WPF Reporting Framework.
Using the XamDataGrid and the DataPresenterExcelExporter - you would be able to export the content of the XamDataGrid in a worksheet. More about the exporting of the XamDataGrid you can find on the following link from our website: http://ko.infragistics.com/samples/wpf/data-grid/export-to-excel.
More about the WPF Reporting Framework you can find on the following link from our documentation: http://help.infragistics.com/Help/Doc/WPF/2015.2/CLR4.0/html/WPF_Reporting.html.
Please do not hesitate to let me know if you have any further questions on this matter.