>>>It seems you need it for a report, isn't it. If this is the case, the easiest way is to do it directly in the report.
>>>
>>>Vlad
>>
>>I am generating the reports from program itself, not by report designer thats why I'm trying to find the sql or any other method, but not report.
>
>Why don't you want to use the report designer??
>
>Vlad

I have a option in my software to create reports, all together there are 8-10 files in my project(dbf's). I have given option of field seletion, filter setting, outputing report to txt, excel, grid, screen, printer.

This is actually a project, transfered from fpw2.6 to visual and before, I made a very long routine to achieve the same thing.

As now i have converted it to vfp, where i have made major changes to my project, including pageframes, etc. This section is still same and processing is very slow.

Thats why I was looking for a faster solution. Pls advs your suggestions.