Can't see all tables in DB

Posted on 2005-05-09
Medium Priority
Last Modified: 2008-01-09

Some months ago I developed few crystal reports based reports to be displayed through a JSP based website. Now I need to produce a new report, however for some reason I can't see tables not used in my previous reports.

How can I view all the tables and all the fields in the database? Has anyone else come across this problem I am facing?

Any help would be useful....


Question by:iam_david_lee
1 Comment
LVL 101

Accepted Solution

mlmcc earned 500 total points
ID: 13961848
If you are trying to use the same database connection then it doesn't know about the new tables.

Instead of using the existing/favorite create a new connection.

Another way that might work is to VERIFY THE DATABASE from the new report

You may also need to logout of the database and log back in.

I assume you have permissions to the tables.


Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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. …
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 …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month14 days, 21 hours left to enroll

839 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