You can apply the ranges within the Query Wizard for the report - Either as a relation or as a range (when init of the data-source is required)

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

The following illustrates a range for the table CompanyInfo - Please remember to set the Lock
Also possible to use an expression to set the value - Like setting the value for the field DataArea in the following.

Please ensure to mark the Cross company 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.

The field dataAreaId used within a relation -->

The field dataAreaId used for setting a range