Added Table not showing SQL Query
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17484
Printed Date: 03 May 2024 at 12:46am
Topic: Added Table not showing SQL Query
Posted By: cruser2
Subject: Added Table not showing SQL Query
Date Posted: 03 Sep 2012 at 5:32am
|
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 |
Hi, I am modifying an existing report which has 4 tables under the Database Fields section.Replies:
Posted By: hilfy
Date 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 ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |