I have Crystal Report that have SQL Server stored procedures as the data source. There are hundreds of existing reports. I don't want to modify the stored procedures at all. Each stored procedure is passed a string parameter with filter conditions; mostly simple conditions like 'ccustno > 'ABC'.

I added in statements to the filter condition to reference SQL Server temp tables that I create from the VFP program that calls the crystal report. But, so far, I have to make them global temp tables (##) instead of #. I think this is because they are on a separate connection handle that I create from within VFP.

My question is, can I use the same connection handle that Crystal reports is using to create my temp tables? Is the connection handle number exposed anywhere in the crystal RDC object. I am using Crystal 8.5. I didn't see it anywhere in any of the object properties.
If not in the object, is there any other way to get it.

Thanks in advance for any suggestions.