Comparison of report types

Reporting and Analysis users can create ad hoc reports, standard reports, and custom reports. The reports contain data from different sources, and vary in complexity.

Report comparison

Report type	Ad hoc	Standard	Custom
Design complexity	Simple to medium	Medium	Simple to advanced
Data source	Model	Model and SQL	Model and SQL
Database schema	Reporting	Reporting	Transactional and Reporting and Analysis
Revisions	Current*	Current**	All
Data blinding	Inherent in model	In SQL	In SQL

* For ad hoc reports, you can see all revisions for operational data only.

** The audit trail standard report covers all revisions.