Solved

Some Tables not listed in Crystal Reports 9

Posted on 2004-10-06
9
326 Views
Last Modified: 2011-09-20
I have CR9 client version. I created a ODBC connection pointing IDBM DB2 database. After creating a connection, I am getting the list of all tables particular to that instance, only a few tables are listed. I checked this in couple of other machines, they working perfectly there.

If I connect to some other ODBC Data source, it lists all tables..

I checked my settings. Its fine. Also I am not able to see views and stored procedures in any instances. Due to this, I have to switch machines whenever I have make a change.

Help would be really appreciated.
0
Comment
Question by:gsuresh17
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 43 total points
ID: 12238614
Not sure about CR9 but stored procedures do not display by default in CR8.  The is a setting in the options that needs to be turned on.  This may also be true for views.

Open Crystal (no report needed)
Click FILE-->OPTIONS
On one of the tabs there is an option group for displaying tables, etc
  (I believe it is database tab)
Ensure TABLES, VIEWS, and STORED PROCEDURES are checked

Also ensure the user has permissions to the tables, views, and stored procedures.

Is there a difference in the ODBC connection between the machines that show all and the machine that shows only some?

mlmcc
0
 
LVL 42

Assisted Solution

by:frodoman
frodoman earned 41 total points
ID: 12238882
Normally the behavior you describe in DB2 is because of permissions - the user doesn't have permission to view the 'missing' tables.  It could also be that the tables aren't part of the users library - particularly if you've established a user for the specific purpose of this connection.  On your DB2 system (AS/400?) you may need to add libraries to the user account.

mlmcc's instructions for the views and stored procs are right on the money - this *does* work the same in CR9.  File -> Options -> Database.

frodoman
0
 
LVL 10

Assisted Solution

by:ebolek
ebolek earned 41 total points
ID: 12242558
Open your database and try to get into the table or sp with the user that is accessing the report. You will see that the table and stored procedure will not be accessible. User dont have the permission to execute the sp or read from the table. Give the necessary permissions to the appropriate user from the database. Then you will have access to those tables.

Regards
Emre
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 

Author Comment

by:gsuresh17
ID: 12242601
Working with DBA to fix this, probably once fixed I would close this.

From the File->Options->Database tab, I have configured earlier to list Tables, SP's Views, Synonmns, etc., But I am not still able to get SP's & Views even now.
0
 
LVL 10

Expert Comment

by:ebolek
ID: 12242686
From the File->Options->Database
In the data explorer box
you should see
1. table
2.view
3. stord procedure
and check boxes next to them .

Check the necessary ones and click OK. Save your report
0
 
LVL 10

Expert Comment

by:ebolek
ID: 12463051
Recommend split between mlmcc, frodoman, ebolek

All the answers are right

Regards
Emre
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

761 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question