Database Reference
In-Depth Information
7.
From the
Av a i l a b l e C o m p o n e n t s
pane, drag the
Retailer Type
query item from
FinalQuery
into the
Expression Definition
.
8.
Va l i d a t e t h e e x p r e s s i o n a n d c l i c k
OK
.
Since the page break setup has already associated the
FinalQuery
with the
Page
object,
there are no other settings that need to be changed at this point.
9.
Click the
Layout Calculation
you just created to select it.
10.
Change the
Class
property to
Report Title Text
.
Yo u r report design within IBM Cognos Report Studio should look similar to the one
shown in Figure 5.18.
Figure 5.18
Final report page design
11.
Run your report in HTML to see results similar to those shown in Figure 5.19.
As you page through the different retailer types, you will notice that Outdoors Shops have
extremely high numbers of long days to close as compared to the other retailer types. At this
point, you could design a drill-though process to get to more specific information, such as indi-
vidual orders for the retailer type grouped by days to close.