Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro Substitution in a Report?
Message
From
12/04/1999 15:18:34
 
 
To
12/04/1999 15:14:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00207535
Message ID:
00207539
Views:
12
>I have a program that needs to report on information from a table, but the system will not be informed of the layout of the table until runtime. I have tried everything I know to set it up so that the reporting routine works regardles of the name of the fiels using macro susbstitution. So far nothing has worked. Any hints?
>
>Thanks in advance...
>
>
>John Dennis

I guess you may use UDFs. For example, use as field expression "GetMyField1":
FUNCTION GetMyField1
DO CASE
CASE Alias()="TABLE1"
Return table1.field5
CASE Alias()="TABLE2"
Return table2.field8
*** etc.
ENDCASE

Instead of Alias(), you may check something else, e.g. FCOUNT(), whatever is more appropriate for your design, some pre-set variable in ultimate case.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform