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
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.
At A Glance
An overview of Aspose.Cells for Reporting Services.
- Text Boxes
- Report Services Formulas
- Dynamic Formulas
- Tables with Grouped Rows
- Tables with Grouped Footer
- MS Query
- Report Specific Data Source
- Shared Data Source
- Pivot Tables
- Interactive Charts
Aspose.Cells for Reporting Services supports Microsoft SQL Server Reporting Services.
- 2008 and 2008 R2
Supported File Formats
Aspose.Cells for Reporting Services supports commonly used spreadsheet file formats.
- Microsoft Excel: XLS, XLSX, XLSM, XLSB, XML
- OpenOffice: ODS
- Web: HTML
- Text: CSV, TSV, TabDelimited text file
- Fixed Layout: XPS
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 the Aspose.Cells.Report.Designer - a simple designing tool that uses Microsoft Excel as a report template. This feature allows to take 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 spreadsheet formats such as XLS, XLSX, XLSM, SpreadsheetML, CSV, Tab Delimited and HTML. Aspose.Cells for Reporting Services also supports ODS (OpenDocument Spreadsheet) file format.
On top of it, Aspose.Cells for Reporting Services exports Excel files 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 exports the reports to Microsoft Excel spreadsheets in such a way that the result appears identical to the original report design as produced 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 close to the original design as possible.
Various Data Handling Options
Aspose.Cells for Reporting Services supports tables with grouped rows and footers whereas the grouping can be setup 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 report 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.
Aspose.Cells offers individual Excel APIs for other popular development environments as listed below: