I have created a Crystal Report using a Microsoft SQL Server OLAP Cube. The cube has three measures; two are plain numeric values and the thrid column is a currency column. I would like to format the currency column with a dollar ($) and Decimal point (.) for only those columns that are for a particular measure. I have tried to place conditional formating on the cell like this:
IF {Measures.Measures, level 0} = 'Total AR Price Amt' THEN
crFloatingCurrencySymbol
ELSE
crNoCurrencySymbol
It isn't working. Does anyone have any suggestions?
IF {Measures.Measures, level 0} = 'Total AR Price Amt' THEN
crFloatingCurrencySymbol
ELSE
crNoCurrencySymbol
It isn't working. Does anyone have any suggestions?