Aras Innovators offers the ability to create reports by using the SQL Server Reporting Services (SSRS). The connection to the report server is done via the rsgateway.aspx.
If reports have to be generated and stored automatically, the following issue arise:
- Every generated report has the name rsgateway.aspx by default.
- Users have to rename and save the Report by themself.
This sample code shows how to:
- Access the SQL report server directly from Aras
- Rename a SQL Report automatically
- Load the report result to the Aras Vault
- Create a new Document with the attached report
This sample works direct from a Method. With some simple modifications it can easy be used in an Action or Form button onClick event.
Aras 11.0 SP9
SQL Server 2012
Aras 11.0 SP9, 11.0 SP12 Aras 12.0 SP7
SQL Server 2012 SQL Server 2022
Internet Explorer 11, Chrome 61.0, Firefox ESR 52.4.0
- Backup your database and store the BAK file in a safe place.
- Navigate to Administration > Methods in the table of contents (TOC).
- Create a new Method (Server-side / C#)
- Insert sample code
- Adjust the report settings inside the code
- Click Run the Method
- Method will create a new Document with the Report attached
- Fork it!
- Create your feature branch:
git checkout -b my-new-feature - Commit your changes:
git commit -am 'Add some feature' - Push to the branch:
git push origin my-new-feature - Submit a pull request :D
This project is published to Github under the Microsoft Public License (MS-PL). See the LICENSE file for license rights and limitations.