Okay I have had this happen before, but totally forgot how to fix it.
I have access to a database, but Crystal does not see the data tables, only system tables. I can write a command object and get data back, but again - the tables aren’t listed for the database.
How do I fix this - is this a permission issue with the database?
Thanks@!
muffntuf 
(BOB member since 2006-01-04)
One thing to check is File -> Options -> Database tab and see if ‘tables’ and ‘view’ are checked or if it is just system tables.
Sanjay Kodidine (BOB member since 2008-03-19)
Yes they are checked, that’s one of the first things I looked at. Incidentally, system tables is not checked. I think it has to do with the ODBC permission as Oracl PL/SQL is only seeing the sys tables as well.
Yet I can write a command object in CR and a direct pl/sql query against the database and get data back.
I have run across this before, but don’t remember how to fix it.
Thanks!
muffntuf (BOB member since 2006-01-04)