Database Reference
In-Depth Information
33.
In the
Properties
pane, change the
Horizontal Alignment
to
Center
.
34.
Double-click the
Size & Overflow
property to open the dialog box.
35.
Change the
Height
to
500 px
and the
Width
to
700 px
.
36.
Click
OK
to close the dialog box.
Now that the prompt page has a nice background, we will add the prompts for the report
within the block.
Step 7: Build Prompts on the Page
The prompts will change the three dimension parameters as well as an option to run a specific
type of analysis.
1.
From the
To o l b o x
tab of the
Insertable Objects
pane, drag a
Ta b l e
object into the
Block
in the work area.
The Insert Table dialog box is displayed.
2.
Change the
Number of columns
to
3
and the
Number of rows
to
2
.
3.
Click
OK
to close the dialog box.
4.
Click the
Select Table
dots in the upper-left corner of the table.
5.
In the
Properties
pane for the
Ta b l e
, double-click the
Margin
property to open the
Margins dialog box.
6.
Set the top margin to
50 px
and the bottom margin to
75 px
.
7.
Click
OK
to close the dialog box.
8.
From the
Insertable Objects
pane, drag a
Te x t I t e m
object into the first table cell.
The Text dialog box is displayed.
9.
Type
Time:
and click
OK
to close the dialog box.
10.
Drag a second
Te x t I t e m
object into the second table cell.
11.
Type
Product:
and click
OK
to close the Text dialog box.
12.
Drag a third
Te x t I t e m
object into the third table cell.
13.
Type
Retailer:
and click
OK
to close the Text dialog box.
14.
From the
To o l b o x
tab, drag a
Tree Prompt
object into the first cell of the second table row.
The Prompt Wizard dialog box is displayed.
15.
Click the radio button for
Use existing parameter
to select it.
16.
Click the drop-down list for the parameters and choose
Selected Time
.
17.
Click
Next
to go to the Populate Control dialog box.
18.
Click the ellipsis next to
Va l u e s t o u s e
to open the Choose Package Item dialog box.
We want to see only the available years in the initial tree prompt view.