Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Formating reports to Excell
Message
From
13/06/1999 12:07:56
 
 
To
12/06/1999 11:44:22
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00229149
Message ID:
00229248
Views:
21
I don't know in VFP build-in capabilities to export reports to Excel file.
You know command:
REPORT FORM RepFileName TO FILE ExpFileName ASCII

It is good idea for future version to have:
REPORT FORM RepFileName TO FILE ExpFileName WINWORD
and
REPORT FORM RepFileName TO FILE ExpFileName EXCEL

I solved this problem with a procedure in which:
1. analyze report file by opening as table.
2. create cursor with data, columns of which corresponds to control sources of each field in report file.
3. Create Excel file with COPY TO.

Nik
Nikolay Petkov, nik@osf.bg
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform