Welcome to the Aspose.Cells for Reporting Services Documentation!

Aspose.Cells for Reporting Services is a comprehensive reporting solution which is the only one of its kind that enables to deliver a variety of interactive and printed reports in native MS Excel format. It makes possible for users to design and deliver their reports directly from MS Excel. Meanwhile it can be seamless integrated with Reporting Services. So, our solution also takes full advantage of the power of Reporting Services' report management, security and delivery options.

Aspose.Cells for Reporting Services is comprised of two parts as following:

• Aspose.Cells.Report.Designer

This is a report designer tool that is integrated with MS Excel in Add-Ins… form. With Aspose.Cells.Report.Designer users can design a report template in MS Excel instead of Visual Studio. The report template is then embedded into Reporting Services RDL file and can be published to Report Server. Users can also preview and export the report in Aspose.Cells.Report.Designer.

• Aspose.Cells.Renderer for Reporting Services

Aspose.Cells.Renderer for Reporting Services is actually an implementation of Microsoft Reporting Services Rendering Extension. It can render RDL reports designed by both Visual Studio and Aspose.Cells.Report.Designer.

Aspose.Cells for Reporting Services is an appropriate solution for users who need to deliver MS Excel reports in Reporting Services. It offers more flexible and user friendly features using Aspose.Cells.Report.Designer tool. All the tasks related to developing reports in Reporting Services such as setting up data sources, creating queries, designing reports and publishing reports to Report Server, can be easily done. What is more, since Aspose.Cells.Report.Designer uses MS Excel as a report template, a user can take full advantage of all the powerful functionalities / features available in MS Excel.

There are two ways to design reports using Aspose.Cells for Reporting Services component. Users can get started with an empty MS Excel template and then complete all the tasks from setting up data sources to publishing reports to Report Server as described above. Another way is to begin with an existing RDL Report in which database queries are available for use. In this procedure, business users have to focus on report design only. This way is useful for those users who want to separate report design work from queries creation work which is relatively complex and has to be done by the users with database and SQL skills.

The sample report is rendered using Aspose.Cells for Reporting Services.