Reporting Services Extension to deliver reports in Excel formats
Export RDL and RDLC reports to Excel formats including more than 8 file formats with great easeDownload Free Trial
Aspose.Cells for Reporting Services
Aspose.Cells for Reporting Services is a rendering extension for SQL Server Reporting Services to embed the ability to read, write and manipulate Excel spreadsheets into their own SSRS applications without relying on Microsoft Excel.
Exporting RDL Reports To Excel File Formats
Aspose.Cells for Reporting Services allows you to deliver native Excel reports in Reporting Services on Microsoft SQL Server 2000, 2005, 2008, 2012 and 2014, as well as in Microsoft Report Viewer 2005 and 2008. Unlike the native renderer for Excel based reports - Aspose.Cells for Reporting Services provides an extended feature set and allows RDL / RDLC reports to be converted to: Excel XLS, SpreadsheetML, XLSX, XLSM, XLSB, CSV, HTML, ODS and TXT formats.
At A Glance
An overview of the formats, report designer, data processing and RDL features that Aspose.Cells for Reporting Services supports.
- 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 2005, 2008, 2012 and 2014 Reporting Services.
Supported File Formats
Aspose.Cells for Reporting Services supports common spreadsheet (XLS, XLSX, XLSB, ODS, CSV, SpreadsheetML), text and meta language file formats.
- Microsoft Excel: XLS, XLSX, XLSB, XML
- OpenOffice: ODS
- Web: HTML
- Text: TXT, CSV
Aspose.Cells Reports Designer Tool
Users can design and deliver reports into Microsoft Excel directly using Aspose.Cells.Report.Designer - this is our simple and easy to use design tool that uses Microsoft Excel as a report template. Users can therefore take advantage of all the powerful functionality and features available within Microsoft Excel including pivot tables, interactive charts, formulas etc.
These attributes are not supported by the standard Microsoft Excel format delivered by Reporting Services. Moreover Aspose.Cells.Report.Designer can create reports in both types of report definition format to support Microsoft SQL Server 2000, 2005 or 2008 Reporting Services.
Flexible Display Options
Aspose.Cells for Reporting Services gives you complete control over page setup and allows you to manipulate a wide range of display options such as: preview page breaks and set zoom level for the worksheet, control data visibility using freeze panes, set page orientation, scaling, paper size, headers and footers, and print area.
Excel Worksheet Security Features
Aspose.Cells for Reporting Services offers a wide range of security features such as support for Microsoft Excel 2007 XLSX file encryption and decryption, protecting a worksheet's contents, objects and scenarios, and hiding or showing a worksheet.
Manipulate Worksheet Rows And Columns
With Aspose.Cells for Reporting Services - easily adjust row height and column width as required. You can also auto size the width and height of cells according to contents, insert or delete, hide or show, and group or ungroup rows and columns.
Aspose.Cells for Reporting Services supports tables with grouped rows and footers. The grouping of rows and footers 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. Users 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. Moreover users can use report specific data sources at design time and specify shared data sources as report data sources while publishing reports.
Comprehensive Excel Worksheet Formatting Support
Using Aspose.Cells for Reporting Services - apply formatting to a worksheet, row, column or cell. You can also add rich text to a single cell and apply different borders, background patterns and fonts. Conditional formatting can also be applied to cells.
Creating Charts And Converting To Images
Aspose.Cells for Reporting Services comes with complete support for charting and supports all standard chart types. You can easily add customized charts using the products API and dynamically set data for the charts. Aspose.Cells for Reporting Services also allows you to convert charts to images.
Convert Worksheets to Images And Vice Versa
Aspose.Cells for Reporting Services provides extensive graphical capabilities - allowing you to easily convert worksheets to images as well as add images to worksheets at runtime.
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.