Report Query Question

From what I have been reading, the Query is referencing a SQL report.  Are all of the SQL reports supposed to show in the SQL section?  I can't get the Report Manager to open, so I am going to have to look into that a bit more.

Does the Report Manager have to be accessed from the SQL server or is it designed to be accessed from a users computer (admin)?

Hi Nathan,

before working with the Report Manager, check if you can access the report server in your environment at all. You should be able to open it in your browser when you know the correct address (e.g. localhost/reports or whatever was specified in your company). There you should find the available reports AND a database connection element were you specify your connection to Innovator.

Hi Nathan,

before working with the Report Manager, check if you can access the report server in your environment at all. You should be able to open it in your browser when you know the correct address (e.g. localhost/reports or whatever was specified in your company). There you should find the available reports AND a database connection element were you specify your connection to Innovator.

Our SQL server is behind a firewall.  I have not been able to access it directly. 

SQL reports can gather data e.g. by an SQL view or SQL query. It´s unlikely that the original report owner used the 'SQL' itemType for specifying the query. Without access to the server there is no chance to see what is happening.

Well, find somebody that has access or at least can send you the used SQL query. :) You don´t need full access to the ReportServer. There normally should be some kind of "Innovator" related section. You can check it´s name in Variable called "Report Server Folder". 

Does this mean the Report Manager report in Aras can only be accessed from the SQL server?

Good question. As far as I think it was possible in the past to access the report server directly. We still have this report manager link when you open a report item:

It never worked for me...

When I run the report s_IPL I receive an error of

The request failed with HTTP status 401: Unauthorized.

Do you know why this would happen?

Regarding HTTPs 401 you could check out these two:

https://community.aras.com/f/community/9295/connecting-ssdt-and-aras-reports/4597#4597

https://github.com/AngelaIp/add-ssrs-reports-to-vault/issues/5

Error 401 can also be caused by wrong or missing SSRS connection string in your InnovatorServerConfig.xml. In this case, you of course also would need access to your server.

If your are open minded to a more progressive approach - You can also try to directly call your SSRS report from Aras. This secret non-official community project shows you how to do it:

github.com/.../add-ssrs-reports-to-vault