Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Heading does not show variable
Message
 
To
02/11/2007 15:49:36
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01266197
Message ID:
01266666
Views:
8
If the report has that same table open in the dataenvironment, it is reopening the table w/o your filter. Remove the table from the dataenvironment if you already have it open and setup like you want.



>I have a report running from VFP 9 and on the heading is a field to display a variable XFilter_set
>
>It is a global variable that is set on startup. It is also reset every time the main form does a refresh.
>I just use code STORE FILTER() TO xfilt on the Refresh one of the fields on the form. The filter does show correctly in that field.
>
>Then I use the Print option that is produced by the standard wizard for quickly building a data input form.
>
>When I run the report the XFilter_set variable is completely different.
>
>For example if the filter is set to CURRENT=.T. it is fine on the form but the report printed shows CfiRt.
>
>If I change filter to STAT=”New” the heading shows SfiTt
>
>I would appreciate any suggestions
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