Database Reference
In-Depth Information
P200_SEARCH that the user can use to filter the report. After you make these report
modifications, you take a closer look at the components and attributes of an APEX re-
port.
Searchable APEX Reports
Reports with Edit links let users scan a list of rows and choose one to modify. Scanning
works well for reports that are short. But when reports are long, especially more than a
page or two, it's time to add some search functionality to help a user quickly zero in on
a record to edit.
Creating a Searchable APEX Report
You've already modified the Tickets report generated by the Master Detail Form Wiz-
ard to add sorting, CSV export capability, and a readable status value. As generated,
the report has an Edit link on the first column, which navigates to a Ticket—Ticket De-
tails master-detail form. For the user to find the correct ticket to edit, you need a search
function. In the next series of steps you add a Search item and a Go button to activate
the search, and you modify the report query to filter on the Search value:
1. Edit
Page 200
of the application.
2. Create a new item in the
Tickets
region by right-clicking the region
name and selecting
Create Page Item
.
3. Select
Text Field
, and click
Next
.
Make sure
Tickets (10)
is selected as the
Region
, and click
Next
.