Last weekend we upgraded our database to 11g and now I am unable to see the list of database tables via the Database expert in Crystal XI. The account that I'm accessing that database with has full access. Immediate help is needed. I have to update 10 reports in 2 days and the deadline is approaching fast. Any help you can send my way will be greatly appreciated.
Please re-post if this is still an issue to the Data Connectivity - Crystal Reports Forum or purchase a case and have a dedicated support engineer work with you directly
I have tried all of that. I am able to connect to the database. That is not the problem.
After connecting to the database you are usually able to see the list of tables within the left side of the data tab within the database expert window. That is no longer the case. I would love to attach a picture so you can see what I'm looking at, but not sure how to do that.
What type of connection that you are using? If you are using ODBC try using native oracle connection and check whether you are able to see the tables or not.
I was able to modify the report with you solution. But since my front end software (Labware LIMS) that my users access these reports from requires that the report be saved with an ODBC connector, they are no longer able to run the reports.
It seems like there should be some solution so that I do not have to build the report with one connector and then relink to the database with an ODBC connector with the hope of not loosing any of my report table, formulas, etc. Once this relinking has been done with the ODBC connector the users are able to run the reports. There must be some other solution. This one seems very unrealistic to me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.