Can Crystal Reports use an existing DB connection?

[Former Member]

Hello,

I have C# app (win forms) that connects to Sybase ASE (15.5) database using ADO.NET.  I have Crystal Reports (version 14.1.1.1036)  used by that application that use use stored procedures on that same server.  The reports now create their own connection; the app provides login credentials via SetDatabaseLogon().  Is it possible that the reports use the C# app's DbConnection to access the database?

Thanks,

John

[former_member11696 · Accepted solution]

Hi John,

We used to be able to do that with an ODBC Connection but no longer. It was difficult to maintain with Clients being updated constantly and so they dropped it. Not many people used it anyways.

So unfortunately no, you will not be able to piggyback on existing connections in CRD or SDK's.

Don

[former_member183750]

As a work-around, you could consider ADO .NET Datasets and pass those to the reports(?).

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter

[Former Member]

Lukek,

Yes, that works,  but its a bit cumbersome using a custom dll data source with the designer.  At least in this case I'm OK with the report using its own connection.

John