Overridden Qualified Table Name issue
We are using Crystal Reports 2008 (version 126.96.36.1990) 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.
Don Williams replied
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: