Skip to main content

How to specify ranges for other root data sources on a CE report - Knowledgebase / D365 CE Connector / D365 CE FAQs - Formpipe Support Portal

How to specify ranges for other root data sources on a CE report

Authors list

This article describes how to apply the ranges within the Query Wizard for a report - either as a relation or as a range.

Log in to the Microsoft Dynamics 365 Finance and Operations and navigate to Lasernet > Reports, then click the Query wizard.


The images below give some examples of a relation and a range using a number of different sources:

The following image illustrates a relation between the entity quotes in D365CE and the table CustTable in D365FO:

The following image illustrates a range for the table CompanyInfo. Remember to set the Lock to Yes.

It is also possible to use an expression to set the value, such as setting the value for the field DataArea in the following image:

Ensure the Cross company is toggled to Yes in case the datasource/table is using the field dataAreId from a table in D365FO.

Both if used within a relation or when used for setting a range.

This image shows the field dataAreaId used within a relation:

This image shows the field dataAreaId used for setting a range:

Helpful Unhelpful

Share