Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Some Tables not listed in Crystal Reports 9

Posted on 2004-10-06
9
Medium Priority
?
331 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 101

Accepted Solution

by:
mlmcc earned 172 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 164 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 164 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
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

 

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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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 …
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

926 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