Software Platform User guide

BusinessObjects Enterprise Repository and shared between many users.
For more information, search for the topic called "Defining an SQL
Command" in the Crystal Reports Online Help.
A Crystal SQL Designer file gathers data from ODBC data sources (such as
SQL servers) by means of SQL (Structured Query Language). The SQL
DBMS handles all of the actual data gathering, sorting, and grouping,
according to the instructions in the SQL statement. Only the final set of data
is stored as a query file.
Note:
If you are not familiar with SQL, see Linking options.
First, you refine an SQL statement and create a query file that contains only
the data you need. Then you design your reports based on the query file
instead of on the original databases. Most of the data gathering process is
done on the SQL server when you design the query. When you design your
report, the Report Designer only needs to work with a small set of data,
saving you time and trouble.
Note:
The file crdb_query.dll must be installed before you can use query files in
your reports.
Crystal Dictionary files
A dictionary (.dc5) file is a structured and simplified view of organizational
data that you can create for any of the individuals in your organization that
are using Crystal Reports. With a dictionary, end users only see the subset
of tables and fields they need.
A dictionary is an optional source of data for Crystal Reports. It provides a
convenient filter, clarifying and simplifying complex data access techniques
for end users, but the user can still access data directly from the database.
Dictionaries simply provide all the convenience without the headaches.
Note:
Crystal Dictionary files were created by a legacy program in Crystal Reports.
While the program is no longer supported, you can still use the resulting DC5
files as report data sources.
Once created, the dictionary acts as a filter, providing a view of complex data
that is clear and easy for any user to understand. The complexity of your
data will not stop end users from creating powerful reports.
746 Crystal Reports 2008 SP3 User's Guide
Accessing Data Sources
26
Crystal Dictionary files