How Do I Configure SharePoint to Show an AgilePoint NX Report?
To configure SharePoint to show a report from AgilePoint NX, do the procedure in this topic.
Prerequisites
- SharePoint Integration in an on-premises environment.
- AgilePoint NX v6.0 Software Update 6 Hotfix 3 or higher.
- The IP address for your AgilePoint NX Portal site.
Good to Know
- This procedure creates a link on your SharePoint site to show your report. When a user clicks this link, the report shows within the context of your SharePoint site.
How to Start
- Open a SharePoint site collection where the AgilePoint App Part or Web Part is installed.
- Click Settings
> Site Contents.
- Click AgilePoint Configuration.
Procedure
- Configure the SharePoint Dashboard to open AgilePoint NX
Report Center.
Title AP Setting Value ReportCenterURL
- Description:
- Specifies the Report Center URL.
Note: The Report Center component (sometimes referred to as AgileReports) can only be used by customers who purchased this component before April 1, 2020. This version is no longer available for purchase, including by current and previous purchasers of AgilePoint NX or the Report Center component. In AgilePoint NX v8.0 and higher, Report Center has been replaced with the Analytics Center component.
- Allowed Values:
- A valid Report Center URL in this format:
http://[Domain]:[Port]/AgileReports
You can find the URL in this key in the file, (NX Portal installation folder - v8.0 and lower) C:\Program Files\AgilePoint\AgilePointWebApplication\AgilePointPortal\web.config.
<add key="ReportsExternalAppPath" value="http://myapnxdomain.com/AgileReports" />
- Default Value:
- None
- Example:
- http://myapnxdomain.com/AgileReports
- In a text editor, open the file [Report Center installation folder]\_Definitions\_Settings.lgx.
- For the AuthenticationClientAddresses attribute, enter the IP addresses for servers that can access reports.
Field Name Definition AuthenticationClientAddresses
- Description:
- Specifies a list of IP addresses for servers that can access
reports.
You must include the IP address for your primary SharePoint server, as well as the IP addresses for any virtual or physical devices that a connection must pass through between your SharePoint server and the AgilePoint Server machine that affects the IP address a client web browser or application uses to access SharePoint. In other words, this is the SharePoint server IP address from the client machine's perspective, rather than the native IP address on the SharePoint machine. These two IP addresses may be the same, or they may be different, depending upon your system configuration.
For example, if there are any physical or virtual switches between your SharePoint server machine and your AgilePoint Server machine that would have an effect on the SharePoint IP address from the client perspective, you must include the IP addresses for those switches. If your AgilePoint Server or SharePoint Server runs on a virtual machine, you must include the IP address for the virtual machine.
- Allowed Values:
- A comma-separated list of IP addresses for servers that can access
reports.
- The list must include the IP address of your AgilePoint NX Portal.
- IP addresses can be complete, or, if they are in the same environment as the Report Center, they can be relative.
- If you want to open reports through SharePoint, enter the IP address for all of your front end SharePoint servers in the list.
- Default Value:
- The IP address for your AgilePoint NX Portal in any supported format.
- Example:
- "::1,127.0.0.1,192.168.245.178, 192.168.245.179, fe80::4497:7360:6f53:af0b%12"
- Create a report view URL using these formats.
Format:
- A direct URL to a report:
[SharePoint Site URL]/_layouts/15/AP/AgileReports.aspx?reportID=ahReport[ReportID]
- A report URL that uses input parameters:
[SharePoint Site URL]/_layouts/15/AP/AgileReports.aspx?reportID=ahReport[ReportID][¶meter1=value1¶meter2=value2]
Example:
- http://myspdomain/_layouts/15/AP/AgileReports.aspx?reportID=ahReport111
- http://myspdomain/_layouts/15/AP/AgileReports.aspx?reportID=ahReport111&company=AgilePoint&Role=developer
- A direct URL to a report:
- Create page on your SharePoint site, create a link to the report. For example, you can create a link on a page within your site, within a link library, or on your site menu.