326 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
in Reporting Services is an expression, which means that it can contain logic and
change its behavior on the fly if necessary. Note also that the measure is wrapped
with a Sum function automatically. This is part of the matrix control??™s default
behavior and while Sum is usually correct, developers are free to replace Sum with
other functions for averages, minimums, maximums, and so on.
In this example, before clicking on the Preview tab, some simple formatting is
applied. The lines of the grid are shown by setting the BorderStyle property of each
cell to Single. The columns are resized and both cells in the second column, containing
years and the measure, have their TextAlign properties set to Right. Finally, the Format
property of the data cell is set to the letter ???c??? which means a currency format. At this
point, clicking on the Preview renders the report, which means the query is executed
and the data placed in the cells. The end result is shown in Figure 10-7. This image
clearly shows how the rows and columns both expand automatically to show the years
across the columns and the countries along the bottom.
Figure 10-7 This is the matrix displaying data from a cube, although at this point the
report contains no interactive features.
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 327
Recall from the earlier discussion that the query is returning all the data contained
in the query that was built, regardless of what is displayed.
Pages:
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415