Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Vilhelm-Ion Praisach
  Where is Vilhelm-Ion Praisach?
 Resita
 Romania
 Vilhelm-Ion Praisach
 To: Ed Burrell
  Where is Ed Burrell?
 Corning
 New York - United States
 Ed Burrell
 Tags
Subject: RE: VFP9 report
Thread ID: 416318 Message ID: 416319 # Views: 75 # Ratings: 4
Version: Visual FoxPro 9 SP2 Category: Visual FreePro
Date: Friday, December 26, 2014 7:33:31 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

In the report don't use (or delete from everywhere) the table name, e.g in the field expressions use only column names.

CREATE CURSOR aa (ii I,xx C(35))
INSERT INTO aa VALUES (25,'On the first day of Christmas')
INSERT INTO aa VALUES (25,'my true love sent to me')
INSERT INTO aa VALUES (25,'A Partridge in a Pear Tree')
INSERT INTO aa VALUES (26,'On the second day of Christmas')
INSERT INTO aa VALUES (26,'my true love sent to me')
INSERT INTO aa VALUES (26,'2 Turtle Doves')
INSERT INTO aa VALUES (26,'and a Partridge in a Pear Tree')
CREATE REPORT comrepo FROM aa
MODIFY REPORT comrepo

CREATE CURSOR bb (ii I,xx C(25))
INSERT INTO bb VALUES (12,'Pretty Angel')
INSERT INTO bb VALUES (11,'Angelina Jolie')

SELECT aa
REPORT FORM comrepo prev
SELECT bb
REPORT FORM comrepo prev



Respectfully

ENTIRE THREAD

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