Database Reference
In-Depth Information
15.
Drag the
Order Method
parameter into the
Expression Definition
area.
16.
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
to close the Report Expression dialog box.
17.
From the
To o l b a r
, click the
Center
button to center the parameter expression in the
report title area.
18.
Change the
Current Block
property value to
3
.
19.
From the
To o l b o x
tab of the
Insertable Objects
pane, drag a
Layout Calculation
object into the
Conditional Block
.
The Report Expression dialog box opens.
20.
Click on the
Parameters
tab of the
Av a i l a b l e C o m p o n e n t s
section of the dialog box.
21.
Drag the
Employee
parameter into the
Expression Definition
area.
22.
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
to close the Report Expression dialog box.
23.
From the toolbar, click the
Center
button to center the parameter expression in the
report title area.
Our report design is completed for this example.
We have achieved the desired result by using a conditional block in a second prompt page,
which will show different second prompt options depending on the selections made on the first
prompt page.
Furthermore, we have integrated the dynamic filter logic without the use of macro func-
tions in order to demonstrate that novice report developers can be quite capable of creating
very complex dynamic prompts and filter reports without advanced macro programming
knowledge.
Finally, we have shown you how to dynamically control what will be shown in the title of
the report based on the user's selections during the prompt process.
Sometimes, the easiest of report requests give report developers the hardest time. The solution is
easy; however, it takes time to find the correct property or “discover” the correct button that does
the trick.
The final result we are trying to achieve should look similar to Figure 1.15.
The order of calculations in more complex data containers, such as crosstabs and charts, can
sometimes cause report developers to get undesired results when summarizing data. In this
example, we will explore the default behavior of summarizations in crosstabs and discover the
alternatives and seldom-used properties.