>>If using the same connection yes.
>
>This is totally external reporting util, something similar to crystal reports. I use an ActiveX provided by Report Manager to do the report execution, that means that I do not have to have VFP open to run a report. I can double click the .rep file and get it to run straight off the data.
>
>>PS: Do you have a solid reason to change to OLEDB. AFAIK OLEDB isn't meant to be faster for retrieval.
>
>Nothing, have to, but on one trial between OLE-DB for ODBC report timing (which I am using) and OLE-DB for VFP timing, IMO OLE-DB for VFP was faster. This was just a single test, I haven't done a test set on it.
>
>An Idea: Can I make a View of the Grouped View and then call this new View which will not have a group by clause?
>
>
>>Cetin
Then I'd find a way to call the command on its connection object first (if there is any).
Making a new view wouldn't help. It'd query the view it's based on in turn.
Cetin