asked on
Not showing all of the Oracle tables in a database when creating new report.
Seem like when i am trying to pull from a specific oracle database the tables stop at the letter P. I have seen some write ups about registry settings, etc. i cannot figure out what the problem is, I changed the ODBC driver version? Does anyone have any thoughts on this? Crystal version 9.
thanks
Danielle
thanks
Danielle
Crystal Reports
Last Comment
daniberes
Does Oracle have any Security Settings in place that are not permitting your login to access those tables...?
Also, are you trying to hit the DB's directly from Crystal...or is there a BUSINESS VIEW or a UNIVERSE in the mix here as well/??
THere are registry settings that control the number of records in a parameter list. I am not aware of a limit on the number of tables.
Do you have over 1000 tables in the database? 1000 is the default limit for a parameter list.
mlmcc
Do you have over 1000 tables in the database? 1000 is the default limit for a parameter list.
mlmcc
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
The users have an oracle client installed and we use the Crystal Oracle ODBC , I have never seen an oracle server connector also I am starting to think that it may be the database which is ClinTrial, a system used for data entry on Clinical studies.
ASKER
This worked, once I used the oracle connector, all the tables showed.
thanks
thanks