There are different combinations of reports and attachments you can include in a composable report, such as:
- A single report and attachments from different tables. For example, a work order report for maintenance on a machine and a PDF file of the machine's specifications.
- A collection of different reports. For example, a balance sheet report, an income statement report, and a trial balance report.
- Multiple iterations of the same report. For example, all unpaid invoice reports for a single customer.
Like normal reports, create and design composable reports in the Report Builder application. Then, create a Report Version application over the composable report so that users can run it.
When you define the report, you must:
- Specify
Composable Reportin the Report Type field. - Select a data source table that contains the records you need to run the report. You may need to create a flat table using a logic block to access all the data you need to run the composable report. Learn more in Flat table reports.
Then, use the Report Builder action to design your report. Instead of creating a detail section that includes fields from the data source table like you would for a normal report, specify composable parts. Composable parts can be either existing reports or attachments.
Report parts
Use a report part to run an existing report based on the records in the composable report's data source table or inputs table. All reports rely on inputs to generate a report output. Usually, these are values that a user enters into a report version application. This means that to run a report as a part of a composable report, you must specify how it receives those input values. Use the fields in your data source table or your inputs table to configure how each report part receives its inputs.
For example, to send a customer all their unpaid invoices, create a composable report and add an invoice report as a composable part. Specify the inputs necessary for the invoice report using fields from the composable report's data source table. If one of those inputs is the Invoice Number field, configure the invoice report to run based on the value found in that field on the data source table. That is, for each data source record, the invoice report runs using the Invoice Number value as an input. After all records in the data source table are processed, all relevant invoice reports are included in the same PDF file.
Attachment parts
Use an attachment part to include attachments on records in the composable report output. When you add an attachment part, specify a table, a filter, and a sort.
For example, you could include a PDF file of a machine’s specifications with the work order to repair the machine. To configure this, you must:
- Add an attachment part after the work order report part.
- Specify the table that contains the records that the specification PDF files are attached to.
- Configure the filters and sorts so that the specifications for the correct machine is included with the work order report.
When the composable report runs, the work order report is immediately followed by the machine specifications in the composable report output.