Databases Reference
In-Depth Information
By default, the interactive report links to something called Single Row View. This view shows a read-only region
that contains all the details about a specific row. In this case, you may want to link back to the form you created on
page 210. Thus you can alter the interactive report to use a more traditional page link instead of the Single Row View.
You do this by editing the Link Column attributes, as shown in Figure
7-59
:
Figure 7-59.
Setting the Link Column attributes
8.
Edit
Page 300
of the application.
9.
Edit the
Analysis
report's interactive report properties by right-clicking its name and
selecting
Edit Report Attributes
.
10.
In the
Link Column
region, set
Link Column
to
Link to Custom Target
.
11.
Make sure
Target
is set to
Page in This Application
, set
Page
to
210
, enter
P210_TICKET_ID
for the
Name
of
Item 1
and
#TICKET_ID#
for the
Value
of
Item 1
, and then click
Apply
Changes
(see Figure
7-59
).
Name and Value tell the link to pass the current ticket's ID (identified by
#TICKET_ID#
) and assign it to
P210_TICKET_ID
in session state.
Run page 300 of your application. You should now be able to drill into the details of any row by clicking in the
column with the Edit link.
Looking Behind the Scenes
Let's look behind the scenes of the interactive report. You may be surprised to see that there is only a single interactive
report region in the Page Rendering region, as shown in Figure
7-60
.