User`s guide

16.4.2 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.
16.5 Query filters and prompts
16.5.1 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.
16.5.1.1 To add a predefined filter to a query
2012-03-14348
Building Queries