# Configuring Union-All Reports

Union-All reports allow you to combine reporting objects into a single object and display the results as stacked rows in the same columns. You can also join Union-All report views with other views using a [Multi-Pass report](/en/lr/55007/).

You can "union" up to ten (10) report objects and add up to 250 fields. Unioned objects behave as a single object in reports.

## Creating Union-All Reports

To create a Union-All [report type](/en/lr/21543/):

  1. Navigate to **Admin > Configuration > Report Types**.
  2. Click **Create**.
  3. Enter a **Label**.
  4. Enter a **Name**.
  5. In the _Class_ drop-down, select **Union-All**.
  6. Click **+ Object** and select an object from the drop-down. You can remove objects by clicking <i class="fas fa-trash"></i>.
  7. Select the applicable field(s) in the drop-down menu. Click <i class="fas fa-plus-circle"></i> to add additional rows. 
  8. Enter a **Union Field Name**.
  9. Optional: Click **Reorder** and drag and drop the objects to reposition them. You can also drag and drop fields.
  10. Click **Save**.

Next, create a [report view](/en/lr/55007/#report-views):

  1. Navigate to **Configuration > Report Views**.
  2. Click **Create**, then select the Union-All report type you created.
  3. Provide a **Name**.
  4. Click **Continue**.
  5. Optional: Add [formula fields][1] to your _Report View_.
  6. Optional: Add **Filters** to your _Report View_. Filter conditions are applied, but not shown, when you run the final report.
  7. Optional: Define columns in your _Report View_ with **Edit Columns**. You can choose from unioned fields defined by the report type or non-unionized fields belonging to specific objects. Columns added to your _Report View_ will appear as default columns, however, all columns will be available for selection.
  8. Optional: [Group rows](/en/lr/55007/#group-rows) by a desired field.
  9. Optional: **Run** the _Report View_ to preview data.
  10. Click **Save**.

Lastly, add the Union-All report to a Multi-Pass report type in order for users to run the report:
  1. Navigate to **Admin > Configuration > Report Types**.
  2. Click **Create**.
  3. Enter a **Label**.
  4. Enter a **Name**.
  5. In the _Class_ drop-down, select **Multi-Pass**.
  6. In the _Report Entity_ drop-down, choose your Union-All report view.
  7. Optional: You can choose to join this view with other available report views.
  8. Click **Save**.

## Formula Fields {#formula-fields}

[Formula fields](/en/lr/52324/) allow you to define formulas in your Union-All reports. You can add formula fields as columns in your report, and use formulas for grouping, sorting, and filtering. You can also use formula fields to define conditional fields and report filters.

You can add a maximum of ten (10) formula fields on each report view.

To define a formula:

  1. Under _Formula Fields_, select **Create Formula Field**.
  2. Select a **Report View**.
  3. Enter a **Label**.
  4. Select a **Return Type**. If you select the _Text_ return type, also enter a **Maximum Length**.
  5. Enter a **Formula Expression**. For more detailed instructions on writing the formula expression, see [Creating Formulas in Vault](/en/lr/42857/).
  6. Click **Check Syntax**. Vault will let you know if your expression is valid.
  7. Click **Save**.

To edit or delete a formula field, click the formula label. You can define up to three (3) formula fields per Union-All report. This does not include formula fields defined in report views.

## Validating Union-All Reports

Vault supports one-to-one mapping on Union-All reports and will not validate the report if you do not select an object or enter a _Union Field Name_.

Vault supports the following data type mapping:

| Data Type | Data Type Supported |
| --- | --- |
| Text | Text |
| ID | ID |
| Number | Number |
| Date | Date |
| DateTime | DateTime |
| Yes/No | Yes/No |
| Picklist | Picklist* |
| Object | Object* |
| Parent Object | Parent Object, Object |
| Lookup | Based on return type |
| Formula | Based on return type |
| Currency | Currency |
| Long Text | Long Text |
| Rich Text | Rich Text |

\* The _Picklist_ and _Object_ data types only support the same picklists and objects as return data types.

## Example Usage

A common example for using Union-All reports includes usage in Quality Vaults. For example, you could treat all _Quality Event_ objects as one object, and join that object to a union of all _Quality Team Member_ objects.


### Demo: Union-All Report Type Enhancements {#Union-All-report-type-enhancements-demo}


This demo demonstrates how to create the above use case by using formula fields and Union-All report types.
<video controls width=860 height =504 poster="https://platform.veevavault.help/assets/images/posters/2026-using-union-all-report-type-enhancement.png " preload="metadata">
    <source src="https://platform.veevavault.help/108e9b1d-559c-4d48-918b-1e4c5b5a533c/383f5bd6-55e3-42fb-a7ed-16dce3b9f611/383f5bd6-55e3-42fb-a7ed-16dce3b9f611_source__v.mp4" type="video/mp4" >
    
    <track
    label="English"
    kind="subtitles"
    srclang="en"
    src="/en/lr/assets/captions/using-union-all-report-enhancement.vtt"
    default />
    </video>

[Details](/en/lr/676768/)


## Limitations

The following limitations apply to Union-All reports:

* You cannot create a standard report using the Union-All report type.
* You can add a maximum of 250 total fields on a Union-All report type.
* Union-All reports do not support filtering on Lifecycle State with the In, Equals, and Not Equal To operators.  
* You cannot combine Long Text and Rich Text fields in a Union-All report type.  
* Report Views for Union-All report types do not support grouping, formula fields, conditional fields, and report running (to be able to preview the view).

[1]: #formula-fields