>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.
In addition to the Transform suggestion, watch out for values larger then what the Format can handle. If the number is 100 (for example) and the Format is '99', then it will display "**", indicating a numeric overflow.
Greg Reichert