>>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.
>
>I don't think you can use a variable in the format expression. Can you prepare the field in advance using transform function?
>
>You can also try ICASE(pcFormatExp = '99', transform(...), pcFormatExp = '', another case, etc.)
Thank you. I will see if transform() could possibly work for me.
"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