Aspose.Cells for Reporting Services

What’s new in Aspose.Cell for Reporting Services V1.5.1?

• Enhanced rendering of editable Charts for SQL Server Reporting Services 2008.
• Set Performance configuration as the default configuration.

What’s new in Aspose.Cell for Reporting Services V1.5?

• Render editable charts for SQL Server Reporting Services 2008
• Support HTML export format
• Modified installation interface

What’s new in Aspose.Cell for Reporting Services V1.4.1?

• Added support for new rendering extension (Xlsm)
• Excel templates with macros are new supported
• Enhanced support for SSRS 2008
• Improved rendering performance

What’s new in Aspose.Cell for Reporting Services V1.4?

• Now supports Microsoft SQL Server 2008 Reporting Services
• Now supports Microsoft SQL Server 2000 Reporting Services
• Now integrates with Microsoft Report Viewer 2008 in Local Mode
• 7 fixes and enhancements

Aspose.Cells for Reporting Services 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

Aspose.Cells for Reporting Services Designer - Users can design and deliver reports into MS Excel directly using the 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, users can take advantage of all the functionalities and 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. Moreover, Aspose.Cells.Report.Designer can create reports in two kinds of report define format to support Microsoft SQL Server 2000, 2005 or 2008 Reporting Services.

Aspose.Cells for Reporting Services Advanced Formulas - There are two types of formulas that you can make use of: one is Reporting Services formulas and the other is MS Excel dynamic formula provided by Aspose.Cells for Reporting Services. Using Reporting Services formulas in Aspose.Cells.Report.Designer is the same as applying formulas in Visual Studio. Users can set Reporting Services formulas based on the values of cells in report template, the formulas will be calculated and the calculation results will be filled back to the cells at rendering time. Comparing it with Reporting Services formulas, MS Excel dynamic formula is not calculated but converted to a real MS Excel formula according to certain rules / regulations and then filled back to Cells at rendering time.

Aspose.Cells for Reporting Services Data Handling - 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 MS Query for creating data sources and queries, which 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 utilize report specific data sources at design time and specify shared data sources as report data sources while publishing reports. Aspose.Cells for Reporting Services is integrated with Microsoft Reporting Services seamlessly and therefore users can take full advantage of Reporting Services' report management, security and delivery options.