Operation Manual

Building Queries

Query filters and prompts

358 Crystal Reports User’s Guide

By default, the Query Panel combines the filters and prompts with the

And operator. You can leave the And operator or change the operator to

Or. See “Using And or Or to combine query filters” on page 363.

2. If necessary, change the operator to Or by double-clicking the And

operator.

Or now displays as the operator. The prompts appear when you click OK,

or when you refresh the report data.

Related topics:

• “Creating query filters” on page 355

• “Building prompts” on page 356

• “Editing and removing query filters” on page 363

Creating advanced query filters

When you filter queries to limit the values returned to your Crystal report, you

apply the filters to the entire data selection in the query. Using advanced

query filters, you can apply filters to dynamic sub-sets of the data that is not

selected in the main query.

Tip: Creating advanced filters requires you to have a good understanding of

query building and filters. For full explanations and examples of how

advanced query filters work, see the Building Reports Using the Web

Intelligence Java Report Panel guide. You can access this guide from the

Help menu of the Web Intelligence Java Report Panel.

There are several steps to creating an advanced query filter:

• Select objects and defining query filters for the main query.

• Select objects for the advanced filter.

• Add simple query filters to the advanced filter.

To select objects and define filters for the main query

• Double-click or drag the objects that you want to include in the report.

The selected objects appear in the Results Objects pane.

To limit the values returned to the report, you can create query filters. The

filters you create are aggregated according to the objects displayed in the

Results Objects pane. For step-by-step instructions on how to define

query filters, see “Creating query filters” on page 355.