My Oracle Support Banner

Difficulty Getting Crystal Reports To Work With A Stored Procedure As A Datasource (Doc ID 1533598.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Utilities Billing Component - Version and later
Information in this document applies to any platform.


The goal of this document concerns the resolution processof an issue occurring when migrating one report from environment to environment as the connection string seems to be embedded in the report. Specifically,a Crystal Report contains a stored procedure. No other reports have this imbeded stored procedure. The problem is that Crystal Reports 2008 appears to be saving the connect string for the database stored procedure in the report file so it only works on the database where it was run and saved.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.