Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Jun Tangunan
 To: Ed Burrell
  Where is Ed Burrell?
 New York - United States
 Ed Burrell
Subject: RE: VFP9 report
Thread ID: 416318 Message ID: 416327 # Views: 60 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Visual FreePro
Date: Friday, December 26, 2014 11:21:28 PM         

> I am not sure how to explain this but I wish to write a report using VFP9 sp2 report writer that takes the information from a table where the name of the table changes: For example it may say Nov14 or Jan14 or any month and year. The fields are the same for each table.
> The table is create through a browse window in foxpro2.6 and use macro-substitution to create the name of the table.
> Any thoughts would be appreciated.
> Thank you in advance for your help.
> Ed

Unless you use more than one recordource for report, then no need to prefix field with table name as vilhelm has said.

Also you can put result on the same cursor name over n over again:

Select * from jantable into cursor junkrep nofilter

Select ... from febtable into cursor junkrep nofilter
Report form...myrep



VFP9 report Posted by Ed Burrell @ 12/26/2014 7:15:48 PM
RE: VFP9 report Posted by Vilhelm-Ion Praisach @ 12/26/2014 7:33:31 PM
RE: VFP9 report Posted by Ed Burrell @ 12/26/2014 8:16:58 PM
RE: VFP9 report Posted by Jun Tangunan @ 12/26/2014 11:21:28 PM
RE: VFP9 report Posted by Ed Burrell @ 12/27/2014 12:58:50 AM