Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to print one record with all child records
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00996520
Message ID:
00996947
Views:
16
Do you have tables opened in the DE of the report or are you just relying on the tables opened in the form?

If the tables are opened in the DE, the table marked as the "InitialSelectedAlias" is the one that drives the reports.

If you are relying on tables already opened in the form, whatever table is "current" at the time the report is run is the one that drives the report.

Also, you have to be very careful when driving a report from a form with a grid. The grid can mess up the selected table by trying to refresh when the report isn't ready. To avoid this, programmatically take focus off the grid before running the report. You can do a search on the UT for the thread that describes that in detail.

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