Formatting a field from a view

[Jay]

I am using a SQL server view as the recordsource of a report. There are decimal fields that I am bringing into the report and it will not let me format it as currency. I do a count in the view and that will come and let me format it as I like, but the decimal fields will not. I want to simply make it currency with 0 decimal points. I have tried using CAST in the view and format([fieldname],'currency') in the report but neither will do the trick. Any advice

Thanks!