formatting numeric to currency for details AND totals

[BlackDice]

I have a cursor that I'm using for a report. One of the fields is Numeric, so on the report, twelve dollars shows as 12.0000. putting the @$ in the format expression makes it $12.0000! I can use a transform on the fields so that it shows as 12.00 or $12.00, but then it's a string, so the total won't display correctly. I'd like to be able to show as a dollar amount in the details section AND the totals section. Any help is appreciated. thanks!!

BlackDice

http://www.stillwaterexpress.com

 

[BlackDice]

Nevermind, I just searched and found a post by craigsboyd that helped me out to do exactly what I needed. Wish I had done that first.

BlackDice

http://www.stillwaterexpress.com