Crystal not seeing all tables

[notadba]

Hi,

Looking at creating some reports in crystal 9 - using the base tables in HCM8.9 rather than just accesing the queries. I have created the ODBC and can connect ok but cannot access all of the tables. I am getting all of the app tables down to the PS_GPNZ... then I get the tools tables (looks like all of them).

Any ideas on why I cannot get the rest of the application tables?

I am using sql server, and connecting in crystal to the database using the sa account. In Query analyzer with the sa account I have access to all tables. Confused!!!

 

[1973kk]

http://technicalsupport.businessobj...sliceId=&dialogID=8936448&stateId=1 0 8938198

 

[notadba]

Thanks for the link - the registry key was not where they said - but that may be caused by the PeopleSoft bundling - but all fixed now.