General information
Category:
Reports & Report designer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only