---
title: "Link Data from Electronic Reports to a Query in Lasernet FO Connector"
slug: "link-data-from-electronic-reports-to-query-in-fo-connector"
description: "This page explains how to link electronic reports data to a Query in Lasernet FO Connector. For more information on Lasernet Tracking, read the rest of the guide."
updated: 2026-03-03T10:27:43Z
published: 2026-03-03T10:27:43Z
canonical: "kb.lasernetgroup.com/link-data-from-electronic-reports-to-query-in-fo-connector"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.lasernetgroup.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Link Data from Electronic Reports to a Query in Lasernet FO Connector

## Prerequisite

Ensure you have configured an electronic report with Lasernet FO Connector.

## Steps

### 1. Select Your Query Report

1. Navigate to **Lasernet** > **Common** > **Reports** and select your previously configured query (see [here](/v1/docs/integrate-electronicreports-with-lasernet-fo-connector-in-fo)).
2. Open the Query Wizard and navigate to the **Tables** form.
3. Add the desired table (for instance, **CustInvoiceJour**).

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-A5KU0X0O.png)

### 2. Add Tables and Fields to the Query

1. Click **Next** and add the desired fields from the **Select fields** form.
2. Finish the Query Wizard.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-5DDPSPEF.png)

### 3. Trigger the Report

1. Navigate to **Accounts receivable** > **Inquiries and reports** > **Invoices** > **Invoice journal**.
2. Select an invoice.
3. Click **Send** > **Original** to trigger the send of the electronic report.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-VH7ZR3CJ.png)

### 4. Preview the XML

1. Navigate back to the Lasernet Archive.
2. If you do not see your newly printed report, click **Refresh**.
3. Once the report is loaded, select it and click **Preview** > **Show XML**.
4. The electronic reporting data will be present in the XML, along with all the records from the **CustInvoiceJour** table.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-SIY6EYSS.png)

### 5. Create a Parameter using an Electronic Report Data Source

1. Select the report in **Lasernet** > **Common** > **Reports** and click **Electronic reports** from the Action pane.
2. Click **Change** on the **Destination** FastTab and then click **Setup** on the **Destination settings** dialog that opens.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-NN83X03C.png)

1. The **Envelope report settings** dialog opens. Create a new parameter by clicking **Add**.
2. Define a **Parameter name** and click **Add**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-KXKTX8U3.png)

1. Click the link icon to open the **Formula designer**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-9S1K6KTP.png)

1. Search for the corresponding field from the electronic report (in this case, **Invoice Number**).

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-UUH2K5TT.png)

1. Select the field and click **Add data source**, then save the change.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-8UWJQ6RP.png)

### 6. Link the Parameter to the Query via a Form link

1. Exit the form and navigate to **Lasernet** > **Common** > **Reports**. Select your query, then click **Form links** on the Action pane.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-GD292AR9.png)

Notice the parameter has been added to the Dialog Setup.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-C66CK41S.png)

1. Click **Default ranges**.
2. Add a new line for the **CustInvoiceJour** table and select the field in your query report that corresponds to this parameter (in this case, **InvoiceId**).

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-0A7K2UUU.png)

1. Click the tool icon to open the Expression Editor.
2. Choose **Parameter** from the **Select value** dropdown list and select the previously created parameter (in this case, **Invoice Number**).

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-DCSTNJT1.png)

1. Click **OK** to close the dialog.

### 7. Reprint the Invoice

1. Navigate back to the Invoice journal and reprint your invoice.
2. Navigate to the Lasernet Archive and select your newly printed report.
3. Click **Preview** > **Show XML**.

The file section will be populated with the electronic reporting data, and thanks to the connection made in the Form Link Dialog Setup, the **CustInvoiceJour** data will now only retrieve the relevant **Invoice Id**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/image-VZG3LGVC.png)