After
these changes, the report might look something like that shown in Figure 10-16.
At this point the report is ready to be viewed by clicking on the Preview tab.
Because no queries were designed for the parameters, they appear simply as text
boxes and the developer must know the correct values to type into the boxes in
Figure 10-16 This is a simple tabular report that will show data from a relational database.
340 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
order to get valid results. This problem will be remedied in a moment, but for now,
the developer can enter Accessories for the Product Category, 2003 for the Year,
and Australia for the Country. Clicking View Report after entering these values
executes the report, as shown in Figure 10-17. Examining the toolbar just below the
parameters shows that this report contains 65 pages, so it is not a small report, by
any means.
Linking Reports
Perhaps one of the most useful features when dealing with Reporting Services is
the ability to link reports. Doing this provides the ability for someone jump from
one report to another, often viewing greater levels of detail. This can be quite useful
when working with data in cubes, which can be aggregated from a large volume of
transactional data. Users sometimes want the ability to see all the records that make
up what they are viewing in the cube. This particular example is a bit higher level
than would be employed in most cases, but it works to show the technique in action.
Pages:
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431