Aspose.Cells for Reporting Services allows you to export native Excel reports in Microsoft SQL Server 2000, 2005 and 2008 Reporting Services. Unlike the built-in renderer for Excel based reports, it provides an extended feature set and allows RDL reports to be converted to: Excel 97-2003 binary XLS format, SpreadsheetML or the Excel2007 XLSX format. With Aspose.Cells Report Designer tool, users can design & deliver reports into MS Excel directly without using Visual Studio IDE.
Aspose.Cells for Reporting Services is an incredibly versatile component that allows developers to create, manage and manipulate Excel spreadsheets without requiring Microsoft Excel or Microsoft Office to be installed on the system.
Native Excel Format
Aspose.Cells for Reporting Services is a rendering extension for Microsoft SQL Server Reporting Services and Microsoft Report Viewer.
After installing Aspose.Cells for Reporting Services, the following file format export options will be added:
- XLS - Excel Workbook via Aspose.Cells
- Excel2007Xlsx - Excel 2007 via Aspose.Cells
- Excel2007Xlsm - Excel 2007 via Aspose.Cells
- SpreadsheetML - SpreadsheetML via Aspose.Cells
- CSV - CSV via Aspose.Cells
- TXT- TabDelimited text via Aspose.Cells
- HTML - HTML via Aspose.Cells.
There are two types of formulas that users can make use of: one is Reporting Services formulas and the other is MS Excel dynamic formula provided by Aspose.Cells for Reporting Services.
Using Reporting Services formulas in Aspose.Cells.Report.Designer is the exactly the same as applying formulas in Visual Studio.
Recent Changes: It provides support for SQL Server Reporting Services 2012; you may enable the Aspose.Cells.Report.Designer Client Tool provided by Aspose.Cells for Reporting Services and integrate it with Visual Studio for SQL Server Reporting Services 2012 as well. We have also enhanced the custom oriented Tab
Install Support: Install and Uninstall
Supported Languages: English
Additional Requirements: SQL Server Reporting Services 2000, 2005, 2008