Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ed Burrell
  Where is Ed Burrell?
 Corning
 New York - United States
 Ed Burrell
 To: Vilhelm-Ion Praisach
  Where is Vilhelm-Ion Praisach?
 Resita
 Romania
 Vilhelm-Ion Praisach
 Tags
Subject: RE: VFP9 report
Thread ID: 416318 Message ID: 416324 # Views: 49 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Visual FreePro
Date: Friday, December 26, 2014 8:16:58 PM         
   


Thank you. This worked fine


> > 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