Aspose.Cells for Reporting Services

Aspose.Cells for Reporting Services seamlessly adds a myriad of features in the Microsoft SQL Server Reporting Services, ranging from setting up data sources, creating queries, designing reports, and publishing them to the Report Server.

Features

• Fully supports the RDL specification.
• Aspose.Cells.Report.Designer client tool to design and manipulate RDL report files.
• Supports using Reporting Services Formulas.
• Generate an RDL file at design time.
• Export the Standard RDL reports to MS Excel.
• Ability to create data sources and queries.
• Supports pivot tables, VBA, macros, and interactive charts.
• Handy command bar icons and tools on Aspose.Cells.Report.Designer add-in's toolbar.
• Join markers together as a composite marker.
• Embed a sub-report in a table group row.
• Support for Microsoft Report Viewer integration in local mode.
• Export reports to various popular supported file formats.
• Support for editable charts.

Supported Input Formats

• Report Definition Language (RDL)
• Report Definition Language Client (RDLC)

Supported Output Formats

• Microsoft Excel: XLS, XLSX, XLSM, XLSB, CSV, TSV, TabDelimited, SpreadsheetML
• OpenDocument: ODS
• Markup: HTML, Markdown (MD)
• Other: XPS

Supported RDL Elements

• Page, headers, footers
• Textboxes
• Images
• Charts
• Lists
• Tables
• Matrices
• Styles
• Rectangles, lines
• Subreports
• Tablix
• Gauge

System Requirements

Aspose.Cells for Reporting Services (including the Aspose.Cells.ReportingServices client, add-ins to Microsoft Excel and Aspose.Cells.ReportingServices Server) needs to be installed properly. Moreover, Microsoft SQL Server should be installed prior to installing Aspose.Cells for Reporting Services.

Microsoft Office

• Microsoft Excel 2000 Install the lockbackRegKey.msi to fix a CLR issue on Microsoft Office machines older than Office 2003.
• Microsoft Excel 2002 Install lockbackRegKey.msi to fix a CLR issue on Microsoft Office machines older than Office 2003.
• Microsoft Excel 2003 Always Update to Office 2003 (KB907417). This update corrects a potential problem in which an add-in, a smart tag, or a smart document may not load if it uses the Microsoft .NET Framework 2.0.
• Microsoft Excel 2007
• Microsoft Excel 2010
• Microsoft Excel 2013
• Microsoft Excel 2016
• Microsoft Excel 2019
• Microsoft Excel 365

Reporting Services

• Microsoft SQL Server Reporting Services 2005
• Microsoft SQL Server Reporting Services 2008
• Microsoft SQL Server Reporting Services 2008 R2
• Microsoft SQL Server Reporting Services 2012
• Microsoft SQL Server Reporting Services 2014
• Microsoft SQL Server Reporting Services 2016
• Microsoft SQL Server Reporting Services 2019

Microsoft Visual Studio

• Microsoft Visual Studio 2005
• Microsoft Visual Studio 2008
• Microsoft Visual Studio 2010
• Microsoft Visual Studio 2015
• Microsoft Visual Studio 2017
• Microsoft Visual Studio 2019

Operating System

• Microsoft Windows 2000 Server
• Microsoft Windows 2000 Professional
• Microsoft Windows XP Home Edition
• Microsoft Windows XP Professional Edition
• Microsoft Windows XP Professional x64 Edition
• Microsoft Windows 2003 Server
• Microsoft Windows Vista
• Microsoft Windows 7
• Microsoft Windows 10
• Microsoft Windows 2008 Server
• Microsoft Windows 2008 Server R2
• Microsoft Windows 2012 Server
• Microsoft Windows 2012 R2 Server
• Microsoft Windows 2016 Server
• Microsoft Windows 2019 Server

.NET Framework

• .NET Framework 2.0
• .NET Framework 3.5
• .NET Framework 4.x

Pricing

• For detailed plans please visit the Pricing Information page.