Displaying Reports in the Microsoft Dynamics NAV SharePoint Client by Using URLs

In the Microsoft Dynamics NAV SharePoint client, instead of opening a SharePoint site and then opening a report, you can open a report directly by using its Uniform Resource Locator (URL). After you have the URL of a report, you can use it as a hyperlink to the report, which you can include in other sources, such as emails or Word documents, or you can it send to other users.

Important

Certain data in the URL, such as company name, could be considered sensitive information. Use discretion if you distribute URLs that contain the company name, or if it is possible, exclude this information from the URL.

This topic includes the following sections:

  • Example

  • Report URL Syntax

  • Building the Report URL

  • Report URL Parameters

Example

The following address displays report 5 Receivables – Payables for the CRONUS International Ltd. company. The page is displayed in a Microsoft Dynamics NAV Web client that is running on port 8080 of a computer that has the name MySharePointServer.

http://MySharePointServer:6834/_layouts/Dynamics/Framework/report.aspx?company=CRONUS%20International%20Ltd.&report=5

There are several parameters that define the address for the report. These parameters are described in the URL Parameters section of this topic.

Note

Unlike pages, you cannot filter the data in a report using the URL.

Report URL Syntax

The URL for opening a report in the Microsoft Dynamics NAV Web client has the following syntax.

<http|https>://<sharepointserver>[:<port>][/<site>]/_layouts/Dynamics/Framework/report.aspx?report=<ID>&[company=<companyname>]

Syntax Key

The following table describes the notation that is used to indicate address syntax.

Notation Description

Text without brackets

Parameters that you must type as shown.

<>

A placeholder for values that you must supply. Do not include the brackets in the address.

[ ]

Optional parameters. Do not include the brackets in the address.

|

A set of values from which to choose. Use one of the options and do not include | in the address.

Building the Report URL

Use the following guidelines to write report URL syntax and create a URL:

  • Place parameters in any order after report.aspx? because the order is not important. For example, report.aspx?company=CRONUS%20International%20Ltd.&report=5 yields the same as report.aspx? report=5&company=CRONUS%20International%20Ltd..

  • Separate parameters after aspx? with &.

  • Use %20 for any spaces in values and names.

Report URL Parameters

The following table describes the parameters of the URL for displaying a report.

Parameter Description

http|https

Specifies the internet protocol to use. Valid options are http and https.

The https protocol helps secure the Microsoft Dynamics NAV data that is transmitted over the Internet. To use https, Secure Sockets Layer (SSL) must be enabled on the connection to Microsoft Dynamics NAV Portal Framework. For more information, see How to: Configure SSL to Secure the Connection to Microsoft Dynamics NAV Portal Framework.

sharepointserver

Specifies the name of the computer that is running SharePoint server and Microsoft Dynamics NAV Portal Framework.

port

Specifies the server port of the SharePoint site that is running Microsoft Dynamics NAV Portal Framework.

site

Specifies the URL path and name of the SharePoint site in which to display the report. If you do not specify a site, then the root or top-level site is served.

A SharePoint web application consists of collection of one or more sites. For example, a web application company might have different sites for each department. Each site has its own path and name on the port it is run and sites will typically be arranged in hierarchical structure.

report.aspx

Specifies the name of the active server page (.aspx) file to use to display the report.

Hh997117.note(en-us,NAV.70).gifNote
Instead of report.aspx, you can also use any of the following aspx files that are associated with pages: card.aspx, list.aspx, or blank.aspx. Microsoft Dynamics NAV Portal Framework will automatically redirect to the report.aspx, regardless of the type that you set.

company

The name of the company in Microsoft Dynamics NAV for which you want to display the page.

If you do not choose a company, then Microsoft Dynamics NAV Portal Framework uses the company that is defined in its web.config file. If no company is defined in the web.config file, then the last company opened by the user is used.

ID

The ID of the report in Microsoft Dynamics NAV.

See Also

Concepts

Displaying Reports in the Microsoft Dynamics NAV SharePoint Client
Reports
Displaying Pages in the Microsoft Dynamics NAV SharePoint Client by Using URLs