Crystal Reports Beginner -  Database SQL Query is greyed out

Posted on 2005-03-03
Medium Priority
Last Modified: 2008-01-09
Crystal Reports 8.5 I have a report that has 2 tables I want to add a third but In design view if I select Show SQL Query its greyed out.  If I click on Insert Field Object and click on Database Fields I dont get an option to add another table.  How do I do this please.
Question by:Northumberland
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
  • 2
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 13452935
There should be an option to add tables

Open the report
Click DATABASE --> Add/Remove Table (may not be correct but it is near the top of the DATABASE drop down)


Author Comment

ID: 13453228
Under 8.5 its called Visual Linking Expert but thanks.
LVL 34

Expert Comment

by:Brian Crowe
ID: 13453239
Database -> Visual Linking Expert... -> [Tables] -> [Add Table...]
LVL 101

Expert Comment

ID: 13453782
I don't have CR on this machine so I was trying to remember.  I felt the menu option was wrong but couldn't think of what it was.
Glad you found it.


Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

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. …
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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month8 days, 16 hours left to enroll

764 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