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?
 
mlmccConnect With a Mentor Commented:
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
 
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
wilko100Author Commented:
Yeah looked in that and that also has got ticks against Show: Tables views. Still returing only sys tables
0
 
wilko100Author Commented:
The ODBC account is also set as the owner (dbo) on that database (and subsequent tables)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.