Database Reference
In-Depth Information
39.
Set the
Va l u e s t o d i s p l a y
value to
[Sales (query)].[Employee by region].[Employee
name]
.
40.
Click on the
Finish
button to close the Prompt Wizard dialog box.
Our second prompt page design is finished at this point. It can be enhanced by the addi-
tion of text boxes for additional instructions to the users, or prompt controls can be mod-
ified to have a different UI.
Yo u c a n n o w t e s t t h e r e p o r t p r o m p t p a g e fl o w.
Step 5: Adjust the Report Title to Show the Selected Prompt Value
The objective is to dynamically display the prompt selections that the user selected at runtime.
1.
Mouse over
Page Explorer
and select the
Page1
object.
2.
From the
To o l b o x
tab of the
Insertable Objects
pane, drag the
Conditional Blocks
object into the page header area below the report title block.
We will reuse the variable we created for the purposes of the second prompt page.
3.
Click on the
Conditional Block
object we have just inserted, and double-click on the
Block Variable
property in the
Properties
pane.
The Block Variable dialog box opens.
4.
From the
Va l u e
drop-down menu, select the
choice
variable that was created during the
second prompt page design.
5.
Click
OK
to close the Block Variable dialog box.
6.
Change the
Conditional Block
property value from
(Other)
to
1
.
7.
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.
8.
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.
9.
Drag the
Date
parameter into the
Expression Definition
area.
10.
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.
11.
From the
To o l b a r
, click the
Center
button to center the parameter expression in the
report title area.
12.
Change the
Current Block
property value to
2
.
13.
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.
14.
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.