Import data in to a Microsoft Word disclosure report
Import and insert data and reports into a Microsoft Word disclosure report document from a ServiceNow instance. You can only import and insert the data that is configured in your reporting configurations.
Before you begin
Role required: sn_esg_msoff_intg.reader
Procedure
- Navigate to the Microsoft Word document in which you want to insert data.
-
On the ribbon, select Insert Link.
On the right side pane, the ServiceNow log in screen appears.
-
To log in to your ServiceNow instance, select
Log in.
- A message is displayed that states that ServiceNow Reporting will display in a new window, select Allow.
- On the ServiceNow login screen, provide your credentials.
- Select Allow.
-
To insert an Operational Sustainability Management data point from a table into the document, move the cursor at the point where you want to insert data.
- Select the Data tab on the right side pane.
- The Business domain field is set to Operational Sustainability Management.
-
In the Reporting Item field, select the Microsoft 365 reporting configuration record you want to insert.
The additional filters dynamically appear based on the configuration record selected.
- In the Value to insert field, select the column from which you want to insert data.
- Select Add.
-
To insert data in HTML format move the cursor at the point where you want to insert data.
- Select the Data tab on the right side pane.
- The Business domain field is set to Operational Sustainability Management.
- In the Reporting item field, select the configured report that you want to insert.
- In the Metric definition field, select the Metric definition that contains the HTML content you want.
- In the Response field, select the HTML content you want.
- In the Value to insert field, select Response
- Select Add.
The HTML content excluding images is inserted in to the disclosure report document. -
To insert a report, move the cursor at the point where you want to insert
data.
- Select the Table tab on the right side pane.
- The Business domain field is set to Operational Sustainability Management.
- In the Reporting item field, select the configured report that you want to insert.
- Select Add.
The data is inserted in to the disclosure report document. The inserted text takes the formatting of the document. You can modify the formatting as required. -
To insert a chart, move the cursor at the point where you want to insert the chart.
- Select the Chart tab on the right side pane.
- The Business domain field is set to Operational Sustainability Management.
- In the Reporting item field, select the configured report that you want to insert.
- Select Add.
The chart is inserted in to the disclosure report document. The inserted chart can be modified according to your preferences. For example, you can change the colors, the type of chart and so on. - To copy the document ID, select the copy icon.
- To view the details of any record that is inserted in the document, select the content control, and then select Open link.
-
To view the list of all ServiceNow links that you’ve inserted in the report and obtain the latest data on the document, select Manage Links.
- Select the check boxes for the links that you want to refresh.
-
Select the refresh icon.
The data is refreshed while displaying the time of refresh and retaining the formatting of the document.
-
To identify and highlight which content control is selected on the report, select the three vertical dots or the more actions icon.
The content control is highlighted in the right pane.
- To create a claim to be used in the disclosure report, refer to Create a claim from Microsoft Word.