Introduction
Copy
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 2019, and any customer with a SQL Server 2019 license can install Reporting Services. (See installation instructions below).
Note
Microsoft SQL Server Reporting Services is not available starting with Microsoft SQL Server 2025. This guide applies to environments running SQL Server 2016. See Microsoft SQL Server Reporting Services Feature Discontinued in the Aras Innovator 40 Release Notes for details on affected versions and recommended alternatives.
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