Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports and OLAP Cubes

Status
Not open for further replies.

hjmoffitt

Programmer
Oct 23, 2000
14
0
0
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top