Reporting Services - Professional SQL Server Analysis Services 2005 with MDX - page 910

profit amount is positive or negative we will use the VBA function IIF.
Set the expression for Color to check if the value for profit is greater
than zero. If yes, the function will return the color green, or else the
color red. Once you specify the expression your expression window
should look like Figure 17-30 . Click the OK button.
Figure 17-30
If you preview the report after setting the colors you will see a report as
shown in Figure 17-31 . You have seen some of the enhancements that can
be made to your UDM reports using Report Designer. Next you will look at
some of the new extensions in Reporting Services 2005 that have been spe-
cifically added to have a tighter integration with Analysis Services 2005.