Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal report designer 9 professional not dispalying all tables 1

Status
Not open for further replies.

awodi

Programmer
Jul 13, 2004
8
GB
Hello,

I have a licensed crystal report 9.0 professional that came with a ERP app that am using and when I try to via all the tables from the sql server db, it doesn't display all but when I use queries, I can select some of those tables.

Can anyone help with this pls?
 
Hi,
Check the options tab on the 'choose data source' panel and be sure tables and views and, optionally, synonyms are selected..Also be sure no criteria are entered in the 2 boxes ( Owner and Table name)



[profile]
 
Thanks Turkbear, Iwill look into it. I will investigate it.
 
Hello again,
I just tried Turkbark suggestions but no luck still. I have about 34000 table in the MS SQL server db. A version 6 of crysal report displays all the table though.

Some body help pls.

 
Turk,Vidru, thank you so much for all the help. I will apply the changes now. tek-tips rocks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top