Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing Paper Trays
Message
From
22/03/2009 14:08:06
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Changing Paper Trays
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01390411
Message ID:
01390411
Views:
100
I am trying the approach from Cathy Pountney’s book “The Visual FoxPro Report Writer: Pushing it to the Limit and Beyond” to change the Expr field in MyReport.frx on the fly by editing the "DEFAULTSOURCE=" setting. It works fine in testing from the command prompt.

Inside my program, it blocked the edit saying that the file was read only. I “excluded” the report from my Project Manager and that problem was solved. The remaining problem happens after I run this from a cmdButton(click) on my form:
ChangeTray("MyReport",3) && Change to Tray 3
report form ("MyReport") preview
When control returns to my calling program, its data environment is empty, giving me messages like “No table is open in the current work area.” My calling form uses a private data session, and my report uses a private data session. The metacode for ChangeTray looks like
parameters tcReportName, tnTray
use (tcReportName + '.frx')
go top
* Put tcReportName.Expr content into the array aLines
* Find the “DEFAULTSOURCE=” line in aLines and change it to new tray #
* Replace tcReportName.Expr with modified content
use
return
I am using the simple SET REPORTBEHAVIOR 80
Any Ideas as to what is causing my problem?

Bob
Next
Reply
Map
View

Click here to load this message in the networking platform