To understand the basics of Results reporting first, click here.

By default, objects must be from the same report query in order to be pulled into the same report table. Otherwise, Apricot Results Reporting (ARR) will display the following error message: "The data objects are not compatible."

If you've created multiple queries, you may want to use objects from each of them throughout the report in various tables. To do this, you must create a kind of object called a merged dimension. Merged dimensions are created from a common object found in the involved queries that make the data objects compatible in a report table.

Follow the steps listed below to learn how to use multiple queries in a single report table.

First, we must determine what object lies in all the queries we want to report on in the same table. The most frequently used objects are identifiers such as Record ID, Parent Record ID, and Link to Record ID.

Note: If you want to create a merged dimension between a Tier 1 form and its Tier 2 form, the commonality between them will always be the Tier 1 form's Record ID object and the Tier 2 form's Parent Record ID object.

In our example report, we've added the Tier 2 Services form's Parent Record ID to our first query and the Tier 2 Program Enrollment form's Parent Record ID to the second query. These both represent the Tier 1 Participant Profile form's Record ID object.

Add your decided identifier into the Results Objects section of each query, then run your queries.

In the Document Objects panel on the right, expand each query that contains the common identifier.

Hold the Ctrl button on your keyboard and click on each instance of the identifier throughout the queries to select them. Then, click on the three-dot icon next to one of the highlighted objects and click Merge.

The report will refresh, and you'll now find a Merged Dimensions section above your Variables in the Document Objects panel. The dimension listed is automatically named after the first identifier object selected from the queries.

Click the three-dot icon next to its name and select Edit Properties to rename the dimension. Note: Spaces are not available when changing the merged dimension's name.

Currently, there are only objects from the first query present in our example report table.

We also want to view Program Name data from the second query in the table, but attempting to pull that object into the table will still result in the "incompatible" error. Instead, we'll create and pull in a variable that references the merged dimension and equals the Program Name object from the second query.

Open the variable editor by clicking '+ Add Variable' above your Document Objects.

Name the variable after the object it represents (ex: Program Name). Then, expand the Qualification dropdown field and select Detail.

An additional dropdown field named 'Associated dimension' will populate below it; click the three-dot icon next to it and select the newly-created merged dimension.

In the formula text box, type an equal sign (=) and double-click the desired object from the second query from the Objects pane to add it to the formula. For example:

Click OK to close the window, and the new detail will appear in the Document Objects panel under Variables. Drag and drop it into the table, and the data will now successfully display.