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 .
4. Enter P200_SEARCH for the Item Name , as shown in Figure 6-47 .
Make sure Tickets (10) is selected as the Region , and click Next .
 
 
Search WWH ::




Custom Search