In this recipe, we are going to create an interactive report and show you how to use it. An interactive report is a special kind of report, which offers a lot of options to the user for filtering, sorting, publishing, and much more.
It's always a good idea to start by creating a view that already selects all columns you want to show in your report. This simplifies the query required for your report region and separates the logic from presentation in your application architecture.
In this recipe, we are going to base the interactive report on the
APP_VW_CONTACTS view that joins the tables for contacts, addresses, and communications. The query for this view is as follows:
select ctt.firstname , ctt.lastname ...