# 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
Reporting tool | Cognos Query Studio | Cognos Report Studio | Cognos Report Studio

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

** The audit trail standard report covers all revisions.

Copyright © 2013 Oracle and/or its affiliates. All rights reserved.