Section 7 · Data and Analytics Management · 17% of exam
7.3 Reports and report types
Exam objective
Describe report formats and types, related-object joins, record inclusion, formulas, buckets, joined reports, summaries, charts, detail hiding, and troubleshooting. A report type determines which objects and fields are available and whether related records are included. Standard report types cover common relationships; custom report types can expose a tailored object relationship and field set. Choose the report type before adding filters or summaries because it defines the report’s data structure. Use tabular, summary, or matrix formats according to how records need to be grouped. Grouping and summary fields reveal totals; charts communicate a selected summary; bucket fields categorize values without creating a new object field. Joined reports compare separate report blocks, while formulas calculate report-level values. Hide details when the audience needs only aggregated results.
If a field is unavailable, check the report type, object relationship, field permissions, and report configuration. If records are missing, inspect filters, record relationships, and the running user’s visibility. Renaming a report column changes its presentation, not the underlying field label.
Additional concepts
Report type defines the data frame
A report type determines the primary object, related objects, fields, and record inclusion available to a report. Choose a report type that includes the records the business wants, including whether primary records without related children should appear. Custom report types can provide a tailored relationship and field set.
Summarize in the right format
Tabular reports list rows; summary reports group rows; matrix reports group by rows and columns; joined reports compare report blocks. Bucket fields group values for analysis without creating a new object field. Formulas and charts add calculations or visual summaries, while hiding details leaves the aggregate view.
A manager needs accounts with and without contacts. Choose a report type that includes accounts without related contacts, then group or summarize the results based on the question.
Key takeaways
- Report types control available objects, fields, and related-record inclusion.
- Grouping, summaries, formulas, buckets, charts, and joined reports serve distinct analysis needs.
- Troubleshoot report structure, filters, field access, and record sharing.
