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 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.
Aspose.Cells offers individual Excel APIs for other popular development environments as listed below: