Naomi suggests preparing the formatted value in advance; in addition to that, you can also use the transform() function in the report expression itself ( I suspect this would be simpler). Just set the report expression to something like:
transform(MyField, pcFormatExp)
>Hi,
>
>I am trying to specify the format of certain column of a report as a variable but so far no success. Here is what I have:
>
>private pcFormatExp
>pcFormatExp = "99"
>
>
>Then in the report, in the Format field, I tried to specify it three different ways:
>1. Simply entering the pcFormatExp in the Format field
>2. Using parenthesis as (pcFormatExp)
>3. Using macro &pcFormatExp.
>
>The value in the field for the column is numeric. But all I see is a bunch of asterisks in the report for this column.
>
>What do I need to change? TIA.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)