Description

Overview
Aspose.Cells for Reporting Services allows you to deliver native Excel reports in Microsoft SQL Server 2000, 2005 and 2008 Reporting Services, 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 features set and allows RDL/RDLC reports to be converted to: Excel 97-2003 binary XLS, SpreadsheetML, the Excel2007 XLSX and the Excel2007 XLSM, CSV, HTML and Txt formats.
Native Excel Format
Aspose.Cells for Reporting Services is a rendering extension for Microsoft SQL Server Reporting Services and Microsoft Report Viewer.
After installing Aspose.Cells for Reporting Services, you will get access to the following additional export formats:
- XLS - Excel Workbook via Aspose.Cells
- Excel2007Xlsx - Excel 2007 via Aspose.Cells
- Excel2007Xlsm - Excel 2007 via Aspose.Cells
- SpreadsheetML - SpreadsheetML via Aspose.Cells
- CSV - CSV via Aspose.Cells
- Txt - TabDelimited text via Aspose.Cells
- Html - Html via Aspose.Cells
Designer
Users can design and deliver reports into MS Excel directly using Aspose.Cells.Report.Designer, which is a very simple and easy to use tool. They don’t necessarily need to use Visual Studio IDE to create reports. As a result, a user can save costs for buying additional Visual Studio licenses and does not have to spend more time in learning how to use complex development environments in Visual Studio. Since Aspose.Cells.Report.Designer uses MS Excel as a report template, therefore users can take advantage of all the powerful functionalities / features available in MS Excel including Pivot Tables, Interactive Charts, VBA, Macros and Formulas. All these attributes are not supported by the standard MS Excel format delivered by Reporting Services.

Syntax Example

This method adds the specified rendering extension to the list of supported extensions in Microsoft Report Viewer using private reflection. [C#] using System.Collections; using System.Reflection; using Microsoft.ReportingServices.ReportRendering; // a WinForms or WebForms application. using Microsoft.Reporting.WinForms; // -- or -- // using Microsoft.Reporting.WebForms; /// <summary> /// <param name="extensionType">The class of the rendering extension to add.</param> private static void AddExtension(ReportViewer viewer, string formatName, Type extensionType) { const BindingFlags flags = BindingFlags.NonPublic | BindingFlags.Public | BindingFlags.Instance; // export formats appear on the dropdown. // Get the service type. FieldInfo previewService = viewer.LocalReport.GetType().GetField("m_previewService", flags); // Get the ListRenderingExtensions method info. MethodInfo listRenderingExtensions = previewService.FieldType.GetMethod("ListRenderingExtensions", flags); // Obtan a list of existing rendering extensions. IList extensions = listRenderingExtensions.Invoke(previewService.GetValue(viewer.LocalReport), null) as IList; // both Report Viewer 2005 (8.0) and 2008 (9.0). Assembly commonAssembly = typeof(IRenderingExtension).Assembly; // Now, get the LocalRenderingExtensionInfo type as it is defined in the same assembly. Type localRenderingExtensionInfoType = commonAssembly.GetType("Microsoft.Reporting.LocalRenderingExtensionInfo"); // Get the LocalRenderingExtensionInfo constructor info. ConstructorInfo ctor = localRenderingExtensionInfoType.GetConstructor(flags, null, new Type[] { typeof(string), typeof(string), typeof(bool), typeof(Type), typeof(bool) }, null); // Create an instance of LocalRenderingExtensionInfo. object instance = ctor.Invoke(new object[] { formatName, formatName, true, extensionType, true }); // Finally, add the info about our rendering extension to the list. extensions.Add(instance); }

Screenshots

Reviews

Submit a review