Skip to Content
avatar image
Former Member

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

step1.jpg (65.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 28, 2012 at 04:55 PM

    Hi Frank,

    Could be the DB client limitation or how CR uses it. Upgrade CR to the same SP 3 as CRS and then upgrade your Oracle Client to 11g also.

    To clarify, you are using CR Native Oracle driver to connect or are you using ODBC or OLE DB?

    I find for migration issues usually ODBC works the easiest due to ANSII 92 Standards. Native drivers don't always follow the rules.

    Check the Platforms for when 11g was added to the supported to verify you are using correctly also.

    Don

    Add comment
    10|10000 characters needed characters exceeded

    • 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