Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro Substitution(&)
Message
 
To
05/01/2001 23:26:51
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00459993
Message ID:
00460220
Views:
21
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform