angela's avatar
angela
Catalyst II
3 years ago

Add report from SQL Reporting Services (SSRS) to an Innovator item

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!

2 Comments

  • eli_donahue's avatar
    eli_donahue
    Community Manager

    Hi angela ! Could you share a GitHub link for this project? If not (or if you don't want to keep this listing up), I'll archive it at the end of the week. We can reopen it in the future if you'd like. Thanks!