How to build Table Reports that combine data from multiple related Workflows
Table Reports provide you with the ability to create reports that combine data from multiple related Workflows into a single report. When creating a Table Report, you will be prompted to select the sources of data for the report. The Workflows selected will determine what Fields can be added to the report. Selecting multiple Workflows is a step-by-step process that reveals additional available Workflows as you progress.
Choose a Primary Workflow
The first step is to choose a primary Workflow as a basis for the report. The selection of the primary Workflow is important for two reasons:
The primary Workflow will control which users can access the report after you create it. Only users with a view or edit entitlement to the primary Workflow will be able to access the report.
A Table Report will always include all Records from the primary Workflow, whereas Records from secondary Workflows will only be included if they have a relationship to the primary Workflow Records.
After clicking the + New Table Report button, you will be prompted to select the primary Workflow and will be able to scroll and search the dropdown to find the correct Workflow.
Choose Secondary Workflows
Click the Checkbox next to a secondary Workflow will mark that Workflow for inclusion in the report dataset.
Once checked, additional related Workflows will be revealed that are directly related to the selected Workflow.
In the example above, after choosing the "Tasks" secondary Workflow, an additional Workflow is revealed. Clicking the checkbox next to the "Communications" Workflow will also mark that for inclusion in the report, but since there are no related Workflows, no additional secondary Workflows will be revealed.
Note: A maximum of 1 primary Workflow plus 3 secondary Workflows can be included in a Table Report.
Once your Workflows have been selected, click Continue to go to the report builder.
Build Reports with Multiple Workflows
The top of the Table Report builder will show the Workflows selected in the upper left.
Note: The source Workflows selected can only be edited during initial creation of the Table Report and cannot be edited after a report is saved.
Fields can be added to the report from any of the Workflows that were selected during the first step. Toggling the highlighted Workflow in the Field finder will reveal Fields from the selected Workflow.
View Reports with Data From Multiple Workflows
When multiple Workflows are combined on a report, you will most likely have cases where a Record is repeated multiple times in the report. This occurs when the primary Workflow is related to multiple secondary Workflow records. Learn more about "duplicate" Records here.
For information on how to view, sort, search, and export data in Table Reports, see our Viewing a Table Report article.
For information on Table Report access and security, see our User Access and Security with Table Reports article.
For information on Visual Reports for table reports, see our Using Table Reports To Filter and Link Workflows for Visual Reports
Please sign in to leave a comment.