Database Reference
In-Depth Information
6.
Replace 'May' with ?Selected Month? The expression should look like this:
[Month (ship date)] = ?Selected Month?
7.
Click OK to close the Detail Filter Expression dialog box.
8.
Double-click the filter for Branch .
9.
Replace 'Bilbao' with ?Selected Branch? . The expression should look like this:
[Branch] = ?Selected Branch?
10.
Click OK to close the Detail Filter Expression dialog box.
Now that the prompting has been added, we can add a title that shows the selected values.
11.
In the Explorer Bar , mouse over the Page Explorer tab and select Page1 .
12.
Double-click the text item in the page header to change the title to the following:
Expected Volume vs. Actual Quantity Shipped for
13.
From the To o l b o x tab of the Insertable Objects pane, drag a Layout Calculation
object to the right of the text in the title.
The Report Expression dialog box is displayed.
14.
In the Report Expression dialog box, type the following:
if( ParamDisplayValue('Selected Branch') <> '' )
then ( ParamDisplayValue('Selected Branch') )
else ( 'All Branches' )
NOTE Be sure to place two single quotes without a space in the opening condition. This
will check to see whether an optional branch was selected by the user.
15.
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 dialog box. If prompted, select April
for the Month and 2005 for the Ye a r .
16.
With the title text highlighted, click the Pick up Style button in the toolbar.
17.
Click the Layout Calculation object next to the text in the title area.
18.
From the toolbar, click the Apply Style button.
19.
To add the parameter values for the date, drag a Block from the To o l b o x tab to the right
of the Layout Calculation in the title area.
20.
Drag a Layout Calculation object from the toolbox and drop it in the newly added block.
21.
In the Report Expression dialog box, type the following:
'For ' + ParamDisplayValue('Selected Month') +
' ' + ParamDisplayValue('Selected Year')
 
 
Search WWH ::




Custom Search