Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Create a Word-based report with Export to Word

This feature is available in Jet Reports 2019R2 and higher

Overview

To help automate the process of getting information out of our ERP system and including that information in existing or new MS Word documents, Jet Reports includes the Export to Word feature.

For our example, let's assume we want to create an Account Statement which shows some customer contact information, that customer's outstanding balance, and details about any open invoices that customer may have:

How-To Video

Setting up a MS Word Template

This video provides a step-by-step overview of configuring the Export to Word feature of Jet Reports.

Step-by-Step

  1. We'll start with a Jet report which contains the data we want to include in our document.

  2. Since our list of outstanding invoices can vary in length from customer to customer, we'll put the report in Design mode so that it's easier to work with and access all the areas we'll want.

    Then, we'll select Configure Word Export from the Jet ribbon.

  3. On the Ranges tab of the Configure Word Export window, we'll begin to define the data we want to include in our Word document.

    For example, we'll start by defining the customer number by entering the NameCustomerNo and then, for the Cell Reference , clicking on the cell that contains the data we want:

    word03.png

    When we select the cell, the address for that cell appears in the Cell Reference

    Since our invoice list is created by a replicating function [ in this case, NL("Rows") ], we want to select all the cells containing the data AND the next blank row, as well. This blank row is referred to as the "anchor row" and its location will move as the number of invoices returned by the NL("Rows") function expand and contract.

  4. Once we have defined all the Ranges we need (and Charts , if our report includes them), we can define the Word template itself.  On the Template tab, click Edit Template .

  5. This will display Microsoft Word. Here, we can use all of Word's capabilities to create our document - e.g., include a logo, add a heading, etc.

    Then from the Jet ribbon in Word, we can use the Insert Range button to include any of our defined Ranges in our document.

    word06.png

    If you've ever created a mail-merge document, the process is very similar Once we're done, we can see that our document is beginning to take shape.  Our text is present and our report data is represented by the Range names that we defined and placed in the document: word07.png

    Note: In most cases, the format of the inserted ranges is preserved from what was specified in Excel. If you need to modify the format of that data (such as bold or italics), you must do this in the Excel report.

  6. Once we close the Word document, we can click Save on the Configure Word Export window.

  7. Now, we can run the report to gather our data and then select Configure Word Export > Generate Word Document from the Jet ribbon:

  8. A dialog appears letting us know that the document is being created. Once the document is ready, we can click on Open File to open it.

  9. Microsoft Word opens and the data from our report is included in the document we defined:

Published:

Create a Word-based report with Export to Word

This feature is available in Jet Reports 2019R2 and higher

Overview

To help automate the process of getting information out of our ERP system and including that information in existing or new MS Word documents, Jet Reports includes the Export to Word feature.

For our example, let's assume we want to create an Account Statement which shows some customer contact information, that customer's outstanding balance, and details about any open invoices that customer may have:

How-To Video

Setting up a MS Word Template

This video provides a step-by-step overview of configuring the Export to Word feature of Jet Reports.

Step-by-Step

  1. We'll start with a Jet report which contains the data we want to include in our document.

  2. Since our list of outstanding invoices can vary in length from customer to customer, we'll put the report in Design mode so that it's easier to work with and access all the areas we'll want.

    Then, we'll select Configure Word Export from the Jet ribbon.

  3. On the Ranges tab of the Configure Word Export window, we'll begin to define the data we want to include in our Word document.

    For example, we'll start by defining the customer number by entering the NameCustomerNo and then, for the Cell Reference , clicking on the cell that contains the data we want:

    word03.png

    When we select the cell, the address for that cell appears in the Cell Reference

    Since our invoice list is created by a replicating function [ in this case, NL("Rows") ], we want to select all the cells containing the data AND the next blank row, as well. This blank row is referred to as the "anchor row" and its location will move as the number of invoices returned by the NL("Rows") function expand and contract.

  4. Once we have defined all the Ranges we need (and Charts , if our report includes them), we can define the Word template itself.  On the Template tab, click Edit Template .

  5. This will display Microsoft Word. Here, we can use all of Word's capabilities to create our document - e.g., include a logo, add a heading, etc.

    Then from the Jet ribbon in Word, we can use the Insert Range button to include any of our defined Ranges in our document.

    word06.png

    If you've ever created a mail-merge document, the process is very similar Once we're done, we can see that our document is beginning to take shape.  Our text is present and our report data is represented by the Range names that we defined and placed in the document: word07.png

    Note: In most cases, the format of the inserted ranges is preserved from what was specified in Excel. If you need to modify the format of that data (such as bold or italics), you must do this in the Excel report.

  6. Once we close the Word document, we can click Save on the Configure Word Export window.

  7. Now, we can run the report to gather our data and then select Configure Word Export > Generate Word Document from the Jet ribbon:

  8. A dialog appears letting us know that the document is being created. Once the document is ready, we can click on Open File to open it.

  9. Microsoft Word opens and the data from our report is included in the document we defined:

For an optimal Community experience, Please view on Desktop