I have a stored procedure that creates a temporary table. Now I want
to get the data from this table and use it with Crystal Report 6. The
problem is, that everytime I try to this, the OCX opens a new connection
to SQL-Server. But the temporary table is only available for the connection,
that created it.

Does anybody have an idea, to say Crystal Report not to open a new
connection everytime or better use the existing connection?

Thx
Enrico Ldecke

Hi Enrico,

The OCX cannot do this.  With Crystal 6, the only way to do this is with the API
calls.  There is a call PELogonSQLServerWithPrivateInfo.  This will allow you to
use an existing ODBC connection to your database.

The other suggestion would be with a newer version of Crystal Reports.  This way
you can use Active Data to use against your reports.  This way you can have your
application run the Stored Procedure and then populate a Data Object with the
recordset.  The report will then be able to connect to the Data Object instead
of the database.

--
Sincerely,
Brian Dong

To reply, remove nospam from the address.