About interactive reports

In this section ShowHide

Interactive report definitions
Valid report definitions

The application provides three types of interactive reports:

Query-based—Reports are based on a query for which you can provide values. The application runs the report against the cases found by the query. You can use the query values as breakdown details in the report.
Summary of all cases—Reports include all cases and generates a report output that can be used as the source data for the tables and graphs in drug profiles.
Customer-specific—Reports provided by Oracle.

Interactive report definitions

An interactive report definition specifies:

Variables from the source data to appear as columns in the report. The definition also specifies how data is broken down based on other variables.
A variable or combination of variables that provide unique keys for the report. The report has a row for each unique key value, or key value combination.
How to aggregate multiple values in individual cells.
The subset of rows to appear in the report, based on conditions specified by a SQL WHERE clause.
Queries for query-based interactive reports.

Valid report definitions

The names of valid report definitions appear in boldface type. A report definition is valid if it includes at least one row variable and one column variable, and no error messages appear for report variables. For a query-based report, a query must be part of the report definition. For an all cases summary report, the definition must conform to certain criteria.