Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing Parent-Child Records to Excell
Message
From
06/09/2006 02:36:50
 
 
To
05/09/2006 09:24:52
David Shedd
Memphis Police Department
Memphis, Tennessee, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01150914
Message ID:
01151207
Views:
26
>Hello all,
>
>I have the need to print to Excel from VFP, the data source is a one to many (Parent on one line and the Child under it). I am having a problem putting the child under the parent, if the parent does not have a child print the next record. Example
>
>Number Date Description of Transaction Debit (-) Credit (+) Balance
>(Parent)
>1404020001 12/20/04 Bank Deposit $1,000.00 $1,000.00
>(Multiple Child)
>1404020001 12/30/04 Transfer to VN $323.78 $676.22
>1404020001 1/22/05 Paid to Family $500.00 $176.22
>1404020001 1/3/05 Paid to Tom Jones $176.22 $0.00
>
>Any help is appreciated!

Have look at CodeRep here in downloads. This can be done
very easy as a simple report. Have look at excel report samples there.
Also hv a look at Rep2Excel.
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Reply
Map
View

Click here to load this message in the networking platform