Introduction

Aras Innovator’s Report ItemType includes support for Microsoft’s ‘Reporting Services’ in addition to supporting the existing XSLT based reports.

Reporting Services is an integral component of SQL Server 2016, and any customer with a SQL Server 2016 license can install Reporting Services. (See installation instructions below).

Usage of this release is recommended only for those with advanced Aras Innovator and SQL training.

Primary benefits to switching from stylesheet driven reports to Report Server:

• Query building is in SQL and is graphical (same as in Enterprise Manager).
• Report definitions are transportable, you can develop on your laptop, and then deploy to a production server.
• Report layout is more drag-n-drop and has more powerful formatting tools.
• The resulting reports are paginated.
• The end-user can easily print, PDF, or export to Excel the report output.
• Excel like Charts and graphs can be produced

To learn more about Microsoft Reporting Services visit: Microsoft SQL Server: Reporting.