>>Can macro substitution (&) be used in a report?
>
>Rip,
>
>I am a strong believer in experiments, as Nadya suggests. In the command window I set
abc = [123]
and in my dummy report I added controls "&abc", "EVAL(abc)" and "(abc)" {name expression}.
>
>Macro expansion doesn't work, EVAL() and the name expression work.
I found the same thing but I was having some problems getting it to work in complicated expressions. So what I did was just use the "&" for readability then I created a little prg that takes the frx file a makes a copy of it. Then I do find and replace for all the known variables that have "&" in front of them and replace them with the field names I need at any particular time. Then I run the report from the copied frx. This way I only have one frx to maintain for several flavors of the same report.
If at first you don't succeed hack the frx.
Rip Ryness
International Falls, MN