---
schema_version: "1"
id: 7883d4fab90f8b1442f6cc861d1fe5da6c814144ba67b4b0caae5d6236b0daf2
title: Joined Report Limits, Limitations, and Allocations
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_unavailable_with_joined_reports.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_unavailable_with_joined_reports.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: cf5335a7c8f48c00ea1b9d563a4f97311357d46862c7a07b3b06e83c89a5d16c
description: Most of the things you can do with reports you can also do with joined reports, such as find, add, and remove fields; summarize fields; and run and save reports. However, there are some things you can’t do. When working with Lightning Experience joined reports, there are some Lightning Experience-specific limits and limitations to consider.
products:
  - Cross Cloud
release: "264"
---
# Joined Report Limits, Limitations, and Allocations

Most of the things you can do with reports you can also do with joined reports, such as find, add, and remove fields; summarize fields; and run and save reports. However, there are some things you can’t do. When working with Lightning Experience joined reports, there are some Lightning Experience-specific limits and limitations to consider.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Lightning Experience and Salesforce Classic</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Enhanced Folder Sharing</td></tr></tbody></table>

Here are some things you can’t do with joined reports.

- Add bucketed fields.
- Add cross filters.
- Drag and drop filters from the Fields pane on to the Filter pane.
- Apply conditional highlighting.
- Change the hierarchy for account, activity, lead, and opportunity reports.
- Create reporting snapshots based on joined reports.
- Schedule or subscribe to joined reports in Salesforce Classic.
- Use table settings from report when adding a Lightning table to a dashboard.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_note.png)

Note

- For users to be able to create and edit joined reports, report builder must be enabled for your entire organization. When report builder isn’t enabled, users can run joined reports, but can’t create them.
- Joined reports require that the new user interface theme is enabled. Users without the new theme are unable to create, edit, or run joined reports.
- Internet Explorer 6 is not supported for joined reports.
- You can’t filter data on a joined report in dashboard view or add a filter to a dashboard that only has joined reports.
- When using the console in run mode, the **Hide Details** and **Show Details** buttons aren't available for joined reports. To use the buttons, click **Customize** to enter edit mode.
- Joined reports aren't supported in console apps.

## Standard Report Types That Can’t Be Used in Joined Reports

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:25.97402597402597%">
          <col style="width:74.02597402597402%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d61469e146">Report Type</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d61469e149">&nbsp;</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e146 ">Accounts and Contacts</td>

            <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e149 ">
              <ul>
                <li>
                  <ul>
                    <li>Account History</li>

                    <li>Account Owners*</li>

                    <li>Contact History</li>

                  </ul>

                </li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e146 ">Activities</td>

            <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e149 ">
              <ul>
                <li>My Delegated Approval Requests*</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e146 ">Administrative</td>

            <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e149 ">
              <ul>
                <li>All Pending Approval Requests*</li>

                <li>API Usage Last 7 Days*</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e146 ">Campaign</td>

            <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e149 ">
              <ul>
                <li>Campaign Call Down*</li>

                <li>Campaign Member</li>

                <li>Campaign Member Analysis*</li>

                <li>Campaigns with Influenced Opportunities</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e146 ">Contract</td>

            <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e149 ">
              <ul>
                <li>Contract History</li>

                <li>Order History</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e146 ">Customer Support</td>

            <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e149 ">
              <ul>
                <li>Case History</li>

                <li>Self Service Usage</li>

                <li>Solution History</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e146 ">File and Content</td>

            <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e149 ">
              <ul>
                <li>Content Authors</li>

                <li>Content Publication Time Frame</li>

                <li>File and Content Downloads</li>

                <li>File and Content Engagement</li>

                <li>File and Content Links</li>

                <li>Library Administrators</li>

                <li>Library Content</li>

                <li>Most Content Downloads</li>

                <li>Most Content Subscriptions</li>

                <li>Stale Content</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e146 ">Lead</td>

            <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e149 ">
              <ul>
                <li>Lead All</li>

                <li>Lead History</li>

                <li>Lead Status*</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e146 ">Opportunity</td>

            <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e149 ">
              <ul>
                <li>Opportunities with Contact Roles and
                  Products</li>

                <li>Opportunities with Opportunity Teams and
                  Products</li>

                <li>Opportunity Field History</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Report Type" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e146 ">Price Books, Products and Assets</td>

            <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d61469e149 ">
              <ul>
                <li>Assets without Products*</li>

              </ul>
            </td>

          </tr>
        </tbody>
      </table>

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_note.png)

Note

- You might not have access to all the report types listed here. Certain factors can affect the report types you see, such as which features your organization has enabled and how your administrator has set up report folder visibility. Check with your administrator if you think you should see a report type that you don’t.
- If your organization has renamed standard objects, the names of the standard report types will contain your organization’s names instead of the original ones. For example, if your organization has renamed the “Opportunity” object as “Deal,” the standard report type “Opportunity Field History” will be renamed “Deal Field History.”
- In this list, report types marked with an asterisk (\*) aren’t available when you create a new report. Instead, you access them by customizing standard reports, which are in folders on the Reports tab.

## Lightning Experience Joined Report Feature Gaps, Differences, and Limitations

As you get ready to work with joined reports in Lightning Experience, take note of these limitations. These features aren’t available yet, but we’re working hard to implement them in a future release.

- Subscriptions
- Export as details only (Formatted report export is supported)
- Open in Quip
- Conditional formatting
- Trend report data in CRM Analytics
- Einstein Discovery in Reports

#### See Also

- [Choose a Report Type in Salesforce Classic](https://help.salesforce.com/s/articleView?id=analytics.reports_builder_selecting_a_report_type.htm&release=264.0.0&type=5 "The report type you choose determines which records and fields appear in your report. For example, the Opportunities report type gives you access to Opportunity records and fields like Amount, Stage, and Type.")
- [Change the Principal Report Type](https://help.salesforce.com/s/articleView?id=analytics.reports_changing_principle.htm&release=264.0.0&type=5 "The principal report type controls how common fields are named. A joined report must have a principal report type. You can change the principal report type at any time.")
- [Combine Different Types of Information in a Joined Report](https://help.salesforce.com/s/articleView?id=analytics.reports_working_with_joined.htm&release=264.0.0&type=5 "The joined report format lets you view different types of information in a single report. A joined report can contain data from multiple standard or custom report types. You can turn any existing report into a joined report using the report builder.")
- [Standard Report Types](https://help.salesforce.com/s/articleView?id=analytics.standard_report_folders.htm&release=264.0.0&type=5 "Salesforce provides a rich collection of standard report types that you can tailor to your unique requirements. You rarely need to create a brand-new report.")