In Innovator various reporting options are available like XSLT, MS SQL Reporting Services (SSRS) or the new Reporting as seen upcoming in the roadmap.
If you use SSRS, this project shows you how to automatically generate a report and store the created file in the Innovator file vault so it can later be used inside regular Innovator items.
The project provides an easy-to-use code sample to understand the connection to the report server.
Scope:
- Call the SQL report server from Aras Innovator
- Rename SQL Report
- Upload the report result to the Innovator Vault
- Create a new Document with the attached report
You can use the code as starting point for various own customizations.
Some ideas:
- Automatically send report as email attachment to certain users
- Add report to zip file that contain further files related to your product
- Transfer report to another software
-...
Note: When using SSRS it can happen that the first report is generated very slowly. This is behavior is caused by the report server. See "Issues" page in linked Github project for a possible solution.
Happy reporting!
