Database Reference
In-Depth Information
28.
From the toolbar, click
Lock (currently unlocked)
.
29.
From the
Run
menu, select
Run Report - PDF
to view the results. Figure 4.21 illus-
trates the new cover page.
Figure 4.21
Cover page
NOTE
In order for the drill-throughs to work, all report pages need to be built. HTML ren-
dering builds only one page at a time. PDF will build the entire report every time.
Now each record status on the cover page has a link to the specific record status pages in
the detail report. Also, the list headings on every page of the detail report have a link to
the top of the cover page.
30.
Close
IBM Cognos Viewer
to return to your report design.
Step 13: Remove the Filters to Run a Full Comparison of the Queries
This last step is optional. We are just completing the report by removing the filters that create a
condition in which we will see all four record status options.
1.
In the
Explorer Bar
, hover over the
Query Explorer
tab and select the
Queries
folder.
2.
In the work area, double-click the
SQL
object attached to the
Legacy_Query
to display
the SQL code.
3.
Remove the line from the
WHERE
clause that filters on the months (
and UNIQUE_
MONTH.MONTH_KEY IN (200504, 200505)
) and then validate the SQL statement.
4.
In the
Explorer Bar
, hover over the
Query Explorer
tab and select the
New_Model_
Query
object.
5.
In the work area, click the filter in the
Detail Filters
pane and delete it.
