Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel reports
Message
From
27/06/2001 16:27:22
Tom Pickel
Corporate Technology Group
Arlington, Texas, United States
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00523238
Message ID:
00524411
Views:
13
If you are creating reports that are just delimeterd columns, Why not use the SQL Select command using the fields as the column name and then copy to filename.xls type xls? The SQL Query is very usefull for reports.

SELECT ;
Field1 AS Column1, ;
Field2 AS Column2, ;
FROM ;
Table1Name.Field1, ;
Table2Name.Field2, ;
WHERE ;
;
AND ;
OR ;
ORDER BY Field1 ;
INTO TABLE OutputTableName
USE OutputTableName
COPY TO ExcelFile.xls TYPE XLS

The output is a column delimetered Excel Spreadsheet. There is also Excel's COM Server. Which is fairly easy to work with.

Tom
Previous
Reply
Map
View

Click here to load this message in the networking platform