Database Reference
In-Depth Information
18.
Click the new value prompt object in the second table cell and change the
Select UI
property to
ListBox
.
19.
Click the ellipsis button within the
Sorting
property of the selected prompt object, and
in the Sorting dialog box, drag
Month (numeric)
from the
Data Items
pane to the
Sort
List
pane. Click
OK
.
This property will sort the months in the prompt control from January to December.
Otherwise, the months will be sorted alphabetically.
20.
Click the page body background and center all the content on the page by clicking the
Center
button on the toolbar.
21.
Click the footer background and center all the footer content on the page by clicking the
Center
button again. All the prompt page action buttons will be centered on the page too.
22.
Click any of the table cells and click the
Select Ancestor
button. Select the
Ta b l e
object.
NOTE
There is a new feature in Cognos 10 that can be used instead of the Select
Ancestor button in this situation. You could have clicked on the three red dots in the upper-
left corner of the table object.
23.
Change the
Margin
property to add
15
pixels of bottom margin.
24.
Run the report to test the prompts. Verify that the prompt page resembles Figure 4.8.
Figure 4.8
Ye a r a n d m o n t h p r o m p t
25.
Close the
IBM Cognos Viewer
window after verifying that the report runs.
Step 10: Create the City Prompt
Now that you have filtered the report for a specific month, you will prompt the report consumer
for the time frame as well as the city.