Crystal reports 9 - not seeing all tables

[notadba]

(This is a cross posting from the PeopleSoft forum)

Hi,

Looking at creating some reports in crystal 9 - using the base tables in my database. I have created the ODBC and can connect ok but cannot access all of the tables. I am getting some of the transactional tables (approx 1500), then the list stops - and then moves on to system/application type tables about another 1000 tables.

Any ideas on why I cannot get the rest of the transactional tables - missing around 1000?

I am using sql server, and connecting in crystal to the database using the system administrator account. In Query analyzer with the same account I have access to all tables. Have I hit a table limit? Confused!!!

 

[IanWaterman]

Not seen this problem before.

You are likely to get more answers if you post in forum
Business Objects: Crystal Reports 2 Data Access. The problem you describe is not really CRystal Enterprise.

Ian

 

[synapsevampire]

Not sure why either, however you may find that if you use the Report-Options->Database->Data Explorer and set the Table Like you can filter for the ones required.

-k