Why Crystal Report save development environment information

[Former Member]

One report, version 11, includes two sub report. Preview is ok in development, called by program is ok too, even change several SQL Server and DB. But after deploy to production, it raise error "Failed to retrieve data from the database. Details: [Database Vendor Code:911]". And after preview production data in Crystal Report designer, and save report template file (Not include data). Called by program to connect production, it is ok. But called by program connect to back development DB, it raise same error. Seems report template file saved development information, and reject program passed DB information.

Thanks very much for your suggestion.

[former_member208657 · Accepted solution]

It sounds like you haven't added any code to change databases at runtime. I suspect the code you thought you were running successfully in dev didn't work to switch DBs. It probably continued to connect to the dev DB.

Saving the original DB info is done by default for a Crystal Report .rpt file. Search the forum and read the developer SDK guide on how to change databases at runtime.

[Former Member · Accepted solution]

This problem is due to miss login DB for a sub report. Thanks Don and David. Since I take long leave and reply today.

[former_member11696]

Moved to .NET Developer Forum, assuming you are using .NET and CR assemblies.

Paste in your code to set logon and table location so we can see what you are doing.

Thank you

Don