Your right, the output and generation of the excel report is slow. You'll have to see what the users think.

There are ways to improve things. You could have a report template that has the headers and static data already loaded, maybe even the formatting. You could also use datatoclip to copy groups of data in one command. It's the between application calls that slow things down. The fewer there are, the faster it will go.

I only use Excel when users want the data in spreadsheet so they can then manipulate it, do charts or email it to others. It's hard to find a way to email a fox report (although using a PDF print driver is a good choice.)


>Thanks Bob,
>
> I want to ask one question. I am using Xls file for output of my report. So i dont have to worry about printer drivers, page length, page setup etc. Is there any other way to put my output of report. (In fox 2.6 for dos we were use @ say command and gives output in modi comm).
>
> But i am facing problem of Very Slow output in xls. I am bit worried because of slow speed, my client will accept this or not. What method you use for output of report? What about word ? is it slow?
>
>Thanks
>Amit