>One of my reports is based upon a view that contains a numberic field. The report has a variable that SUMs the value of that field and the variable is displayed on the report. I want to make the value appear with 2 decimal points and with a dollar sign ($) directly in front of it. I imagine I should use the Format field in the Report Expression dialog. What value do I enter into this field?
Try TRANSFORM(NTOM(
)) as the expression.
Brien R. Givens
Brampwood Systems