Solved

Some Tables not listed in Crystal Reports 9

Posted on 2004-10-06
9
324 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
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 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