Thank you. This is what I plan to try.
>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
