Crystal Reports 8.5

I am trying to create a simple report using 2 tables. I have setup an ODBC connection using SQL Server driver. However in the data explorer i can only see system tables. I have selected to show tables and views in the Options but stil only see sys abd no tables. Any ideas? Crystal image
wilko100Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Do you have permissions to the tables?

mlmcc
0
wilko100Author Commented:
Do you mean in SQL Server? I log in using the same as the ODBC user name and password and can see all the tables in SQL server
0
James0628Commented:
I don't know about CR 8.5, but in CR 10, you have "File > Options" and "File > Report Options".  The "Options" window is used to set default settings for when you're creating new reports, fields, etc.  Changing things there does not affect existing reports, fields, etc.  To change the db settings for an existing report, you have to go to File > "Report Options".

 If CR 8.5 is the same, then maybe you're going to File > Options, instead of "Report Options".

 James
0
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

wilko100Author Commented:
Yeah looked in that and that also has got ticks against Show: Tables views. Still returing only sys tables
0
mlmccCommented:
I assume you scrolled down the table list.

Did you check the permissions on a table to ensure you have READ privilege?
When you log intoo the database you may be able to see a table that you dont have READ permission to but Crystal would not show it.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wilko100Author Commented:
The ODBC account is also set as the owner (dbo) on that database (and subsequent tables)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.