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.
Complex Crosstab Calculations
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.
Design
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.
 
 
 
Search WWH ::




Custom Search