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

To view the SQL after you have created a query
• In Crystal Reports, open a report created with a universe as a data source,
go to the Database menu, and click Show SQL Query.
You can see the SQL in the Show SQL Query dialog box.
Or
In Crystal Reports, open a report created with a universe as a data source,
go to the Database menu, and click Database Expert.
Once you are in the Database Expert, right-click your query in the Selected
Tables list and select View Command. You can see the SQL in the View
Command dialog box.
Query filters and prompts
Creating query filters
You can use the following types of filters in a query:
• Predefined filters
These filters are created by your administrator.
• Custom filters
You define these filters while you are creating the query.
• Prompts
Prompts are dynamic filters that you define to display a question or a list
of values; users can select different filter value(s) each time they refresh
the report.
To add a predefined filter to a query
1. Double-click the objects you want to use in your report, or drag them to
the Results Objects pane.
468 Crystal Reports 2008 SP3 User's Guide
Building Queries 18
Query filters and prompts