Figure 10-17 This is the tabular report after the parameters have been entered and the
report is executed.
C h a p t e r 1 0 : S Q L S e r v e r R e p o r t i n g S e r v i c e s 341
In order to show this, a new and very simple report will be created against the
cube. The query will contain just the year level from the Calendar hierarchy and
the Country level from the Customer Geography hierarchy. The report still has
a parameter on the Product Category, as before, although the parameter does not
allow multiple selections because the SQL statement in the relational report does not
handle multiple selections (this can be modified by using the SQL IN statement).
The report uses a matrix control as before, with the years on the columns and the
countries on the rows, and Internet Sales Amount as the measure. At this point the
report can be run though, aside from selecting a category, the report is not interactive.
The key here is that each cell has an Action property, and this property is able to
call other reports, among other things. Clicking on the data cell (the one containing
the measure, Internet Sales Amount) and viewing the properties in the Properties
window shows the Action property. Clicking in the cell reveals a button with an
ellipsis and clicking that button opens the Action dialog box. The first option is to
jump to an existing report, although the action can also jump to a bookmark (another
section in the same report) or another URL entirely.
Pages:
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432