HP Intelligent Management Center Standard Software Platform - Manual (Page 467)

To edit an existing query
1. In Crystal Reports, open a report created with a universe as a data source,
go to the Database menu, and click Query Panel.
2. Log on to BusinessObjects Enterprise if you have not done so already.
For information about how to log on to BusinessObjects Enterprise, see
Working with Enterprise folders .
3. In the Query Panel, edit your query as necessary.
4. When you have finished editing your query, click OK.
5. Click OK in the Database Expert to return to your report.
Changes that you made in your query are reflected in Crystal Reports.
Note:
If you remove objects from your query that you have used in your Crystal
report, you must remove these objects from the report.
Viewing the SQL behind a query
When you build a query, Crystal Reports automatically generates the SQL
that corresponds to the query and saves it as a Crystal SQL Command
object.
For more information about SQL Command objects, search for "Defining an
SQL Command" in the Crystal Reports Online Help.
To view the SQL when you create a query
•
In the Query Panel, click View SQL.
The SQL dialog box appears; it contains the SQL that constitutes your
query. Use this option when you want to check the SQL as you create a
query.
Crystal Reports 2008 SP3 User's Guide 467
18 Building Queries
Viewing the SQL behind a query