I have a bunch of Crystal Reports that have SQL Server stored procedures as their data source. Each stored procedure is passed a string parameter with filter conditions; mostly simple conditions like 'ccustno > 'ABC'. But I also pass in references to SQL Server temp tables - for example 'select ccustno from arcust where ccustno in (select ccustno from ##temp_arcust)'. The ## temp table is created by my VFP program. 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 execute the stored procedure, 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.