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.

Common Uses

Export RDL reports in the following formats:

- Excel 97-2003 Binary XLS
- SpreadsheetML
- Excel 2007 XLSX
- Excel 2007 XLSM
- CSV
- TXT (Tab Delimited Text)

No Microsoft Excel Automation

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.

Advanced Features

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.