Therefore,
the final setting for the ProductCategory parameter will be:
=LTrim(Parameters!ProductCategory.Label)
342 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
The Year parameter should be relatively simple, but the label that is shown in
the report for the year 2003 is actually CY 2003. In this case, it??™s necessary for the
developer to strip off the leading CY and the space. This is done by using the Right
function, which takes a certain number of characters from the right of the value; in
this case the developer wants the four right-most characters, which are just the date.
The final setting for the Year parameter will be:
=Right(Fields!Calendar_Year.Value,4)
Fortunately there is nothing special that has to be done with the Country parameter,
so the final settings in the parameters dialog box are shown in Figure 10-18. Note that
these changes are unique to this situation, and other cases may call for completely
different manipulation in order to pass parameters.
After the developer sets the Action property, the data is clickable when displayed
in the matrix. By default, the appearance of the numbers doesn??™t change to reflect
that it is now clickable; instead, the developer will have to change text formatting if
he or she desires underlining or color changes to cue the user in.
A final change that is often made is to hide the parameters on the linked report.
Pages:
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434