>>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.
Thank you.
"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
