Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Added Table not showing SQL Query Post Reply Post New Topic
Author Message
cruser2
Newbie
Newbie


Joined: 07 Feb 2012
Online Status: Offline
Posts: 14
Quote cruser2 Replybullet Topic: Added Table not showing SQL Query
    Posted: 03 Sep 2012 at 5:32am

SmileHi, I am modifying an existing report which has 4 tables under the Database Fields section.

 

I have added another table via the database expert to this list from the same existing connection.

 

I have checked the table is linked to one of the existing tables using the same data type and string length.

 

Also checked in the database via another tool that there is matching data for the report to run on this new table.

 

However when I check the query string via Show SQL Query from the Database menu option the new table has not been added.

 

Why is the new table not showing even though it is setup correctly via the link tab of database expert?

 

thanks

IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 04 Sep 2012 at 4:13am
If you haven't used any fields from the table in your report, it won't appear in the query.  Crystal builds its query based on which fields are used somewhere in the report - either on the report itself, in the filter and/or sort, or in any formatting formulas.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.