Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to export report to excel(.xls) file?
- Thread starter diem
- Start date
jackstrawn
Programmer
How about exporting your data to Excel:
EXPORT To filename TYPE XLS
Then report from Excel?
To my knowledge you may only export a report from VFP 7.0 to ACSII.
EXPORT To filename TYPE XLS
Then report from Excel?
To my knowledge you may only export a report from VFP 7.0 to ACSII.
Hi
Prepare a cursor having all fields etc a it would appear in a report. Basicaly, in a report, you can build lot of function and display the result. Instead you create the cursor with all such fields, so that you can reduce the manipulations in excel. So the resulting cursor can eithr be used for casting the report or sent to excel using the following utility.. in the following way..
IF doPrint
REPORT FORM myReport .......
ENDIF
IF doExportExcel
DO DBF2XLS
ENDIF
To get the 'DBF2XLS'... look in the following link...
Hope this is helpful
ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
Prepare a cursor having all fields etc a it would appear in a report. Basicaly, in a report, you can build lot of function and display the result. Instead you create the cursor with all such fields, so that you can reduce the manipulations in excel. So the resulting cursor can eithr be used for casting the report or sent to excel using the following utility.. in the following way..
IF doPrint
REPORT FORM myReport .......
ENDIF
IF doExportExcel
DO DBF2XLS
ENDIF
To get the 'DBF2XLS'... look in the following link...
Hope this is helpful
ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
- Status
