>>>>Sounds like the Crystal report (and print to Excel) is the choice. I guess I have to pick it up.
>>>>
>>>>Thanks.
>>>>
>>>>
>>>>Tai ShihChau
>>>
>>>Good lock, but don't forget it's not as tight integrated vith vfp as other tools; you could also write your own programs to feed Excel.
>>
>>Is there any way to use VFP report to send to Excel?
>
>I don't now about such a way (maybe it's possible), but you don't need VFP report to send data to excel. Excel is an OLE automation client and server, it's really easy to create an excel ole object, to open new spreadsheets, to fill the cells with data and so on, you can use all of the excel functionality from your vfp application. vfp as the fastest database engine and excel for the mathematical and statistical computation power.
>
>Do you need some code ?

I'm thinking of doing a generic 'report to excel' function instead of coding every report. Maybe I can read the report format and generate a simple report to Excel. Any idea?