Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Overridden Qualified Table Name issue

Hi All,

We are using Crystal Reports 2008 (version 12.2.0.290) to develop reports through native oracle driver (10.2.) to connect Oracle 11g Server.

We recently upgraded to Crystal Reports Server 2008 V1 SP3 to run our reports.

There are two issues we are facing at the moment.

1. If we use original db credential to run report on server, it works perfectly. However, if we use customized db login information (ie. from development to testing or production schema), the reports times out.

2. We then try to use OQTN to remove stored schema information in the report. And after type the overridden name, following error message shows: "Data Object cannot be opened/accessed", followed with "Cannot find the QE property".

This happens if we want to override name of oracle package, it does not happen when override name of views. We really struggle to identify the cause of the issue: Whether it is a limitation? or we did something wrong? And it's very time consuming if we need to reset datasource location every time when reports connect to different database schema. Therefore, any advice is more than welcome and appreciated. Thank you.

p.s. the procedures in oracle package usually call another procedures/functions within package, or a standalone function or procedure. Not sure if this affect.

Frank

Former Member
replied

Hi Frank,

Since you are using code to try to replace the connection try this app:

1553921 - Is there a utility that would help in writing database logon code?

Create a report off each source and then run that report through the app and it should give you the option to use the ReplaceConnection API.

Of course if you can't create a report in the designer then it's not going to help.

See this on what CR requires when using SP's and Packages also:

1181947 - Oracle Stored Procedures and Crystal Reports

Don

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question