Solved

Some Tables not listed in Crystal Reports 9

Posted on 2004-10-06
9
327 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

738 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