Reports are built over tables of data that have filters, groups, and other criteria applied to the records. The data source determines where to retrieve information from, and how to filter it before it is used in the report.
There are different types of reports that can be created, as detailed below.
Interactive Reports
Interactive reports are built over a single table, summary table, or data source defined in the Data Catalog application. Multiple report versions can be built over the same data source, each with their own filters, sorts, calculations, and visualizations.
Interactive reports are dynamic and enable users to drill down from the highest level of summary data into the most granular and detailed view of the same data. Learn more in the following topics:
- Ways to build an interactive report
When a data source is selected for an interactive report, the fields and business data from that table become available in the report. The type of data source selected determines if the available data is refined for your specific business process.
- Report versions in interactive reports
Report versions enable you to select different combinations of table layouts, filters, sorts, and visualizations to create multiple reports over the same data source. You can only view the different components in the interactive report if they have been added to a report version.
- Table layouts in interactive reports
Table layouts enable you to create Report Data and Row Details tables with the specific columns, groups, pivots, and aggregates that you want to organize your business data.
- Filter and sorts in interactive reports
Filters and sorts enable you to refine the data shown in your interactive reports, and organize it by ascending or descending values. Interactive reports can have default filters and sorts applied to different report versions.
- Calculated columns in interactive reports
Calculated columns display results of a calculation defined between two or more columns, or two or more values within the same column, in an interactive report.
- Report buckets in interactive reports
Report bucket definitions enable you to dynamically categorize records in interactive reports based on specified date ranges.
- Visualizations in interactive reports
Use visualizations to display data in a visual format, such as a graph or pie chart. Build visualizations in the Visualization Builder accessible from the Application Builder and Interactive Report Builder .
- Links in interactive reports
Links enable you to navigate to related applications, dashboards, or other interactive reports from the Report Viewer.
- Common context in interactive reports
Use common context to populate fields or filters in one application or interactive report based on a value published in another application or report. Or, use common context to create or select a record in an application link based on a published value.
- Advanced configurations for interactive reports
There are optional advanced configurations which you can use in your interactive reports. These configurations require application development experience and security access.
- Interactive reports performance considerations
This topic covers the best practices for improving performance in your interactive reports, and the guidelines for data volume.
- Interactive Reports best practices
These best practices ensure Interactive Reports are configured consistently.
Reports
Report templates and applications are built over a table or flat table to enable users to create reports. Learn more in the following topics:
- Report Builder
Application developers use Report Builder to design report templates with the layouts and data which they want included in them.
- Advanced report builder configurations
There are advanced configuration options that application developers can use for reports.
Interactive Reports best practices
These best practices ensure Interactive Reports are configured consistently.
There are several considerations when you create interactive reports, such as:
- Interactive reports should always be built over View tables.