Database Reference
In-Depth Information
Interactive Reports
Your ticket report is what's called a
classic report
. It's the original style of APEX re-
port and still has practical application in a variety of situations when the requirement is
for a simple list of data with no interactivity. Most applications, including APEX itself,
now employ the APEX interactive report.
Introduced in APEX 3.1, the interactive reports feature allows APEX to quickly and
easily include user-driven ad hoc capabilities in your applications. Interactive reports
are greatly enhanced in APEX 4.2. The beauty of APEX interactive reports is that they
give the end user powerful ad hoc query capability with exactly zero lines of code writ-
ten by the developer. End users can customize the following:
•
Searching
•
Sort order
•
Columns
•
Breaking
•
Highlighting
•
Computations
•
Aggregations
•
Charts
•
Group by
•
Flashback time
•
Saved reports
•
Subscription (e-mail notification)
Interactive reports are technically nothing more than a report type. The Create Re-
port Wizard steps are similar, and you expend the same effort in building an interactive
report as for a classic report.
Classic reports can be easily converted to interactive reports. There is no way to re-
vert from an interactive report to a classic report. (But why would you want to?) The
end-user features and overall value of interactive reports are best illustrated with an ex-
ample, so let's add an interactive report to your application.
