Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Three different modifications of the same report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00607727
Message ID:
00607837
Views:
40
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>I have Number of Sales report, Volume of Sales report and Median Price report. All three of them are almost identical except for some labels and fields, which are used (in Number fields end with "Num", in Volume - with "Vol", in Median - with "Med"). It's a pain to support three different versions of the same report...
>
>Can you suggest a better solution?
>
>Thanks in advance.

Nadya,

Create a private variable before calling the report that is set to "NUM", "VOL" and "MED". In the expression of the Field objects, use EVALUATE('MyField' + MySuffix). For the labels, you can either add three labels to the report, each with the appropriate Print When expression ... or add one Field object with IIF(...) as the expression to figure out what to print.

Cathy
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Reply
Map
View

Click here to load this message in the networking platform