Aspose.Cells  for Reporting Services

Reporting Services Extension to Deliver Reports as Excel Files

Export RDL & RDLC reports to Excel spreadsheet file formats with ease.

  Download Free Trial

Aspose.Cells for Reporting Services allows you to deliver Excel reports from within the Microsoft SQL Server Reporting Services and Microsoft Report Viewer. Unlike the native exporter for Excel based reports - Aspose.Cells for Reporting Services allows the conversion of RDL & RDLC reports to a number of Excel spreadsheet file formats.

Advanced Reporting Services Features

Export MarkDown format file

Support Tablix Group Page Break

Generate Multiple Tabs

Collapse or expand Pivot Table fields

Support performing Minus calculations

Invoke MS Excel printing format

MS Excel 2016 charts supported

Adjust Page margin settings in Excel Sheets

Aspose.Cells' Reports Designer Tool

Developers can design and deliver reports directly from Microsoft Excel while using Aspose.Cells.Report.Designer - a simple designing tool that uses Microsoft Excel as a report template. This feature allows taking advantage of all the powerful functionality and features available within the Microsoft Excel application including Pivot Tables, interactive Charts, formulas and so on.

Export Reports to Spreadsheet Formats

Aspose.Cells for Reporting Services supports all popular Microsoft Excel (97 - 2016) file formats, including “native” Microsoft Excel formats like XLS, XLSX, XLSM, SpreadsheetML, CSV, Tab Delimited and HTML. Aspose.Cells for Reporting Services also support ODS (OpenDocument Spreadsheet) file format.

On top of it, Aspose.Cells for Reporting Services export Excel documents as fully editable spreadsheets, that is; the end user may edit the resultant spreadsheets manually in Microsoft Excel application if required.

High Fidelity - Identical to Report Design

Aspose.Cells for Reporting Services export the reports to Microsoft Excel spreadsheets in a way that the result appears identical to the original one as generated by the built-in Reporting Services report designer. All report features are converted to the highest degree of precision to make Microsoft Excel spreadsheets look as similar to the original one as possible.

Various Data Handling Options

Aspose.Cells for Reporting Services support tables with grouped rows and footers whereas the grouping can be set up at design time like other report items. Aspose.Cells for Reporting Services also supports parameters and global variables as report data sources. Developers can also make use of Microsoft Query for creating data sources and queries; this is a widely used tool and familiar to most users.

In addition to this, Aspose.Cells for Reporting Services supports both reports specific data sources and shared data sources created on Report Server in advance. Developers can use report specific data sources at design time and specify shared data sources as report data sources while publishing reports.

Microsoft Office Automation – Not Needed

Aspose.Cells for Reporting Services is built using managed code that never needs Microsoft Office or Microsoft Excel to be installed on the machine to work with Excel document formats. It is a perfect Microsoft Excel automation alternative in terms of supported features, security, stability, scalability, speed and price.


Support and Learning Resources