Loading

SAP Crytal Report

How to apply Query Filters & Filter Conditions in Crystal Report?. The Complete SAP Crytal Report Developer Course 2022 [Videos].

Following are the types of query filters that can be used in Crystal Reports − Predefined filters Custom Filters Custom Filters

Predefine Filters

These are inbuilt filters in query panel created by the administrator. Predefined filters are created at the Universe level and are directly used in the report from the Universe. Drag an object on which you want to apply filter to query filter pane and drag predefined filters too. When you run the query data w.r.t query filter will be returned in the report.

Custom Filters

These filters are created with the queries in the query panel. Custom filters are created in the Query panel under the query filter tab. Drag the object to the query filter pane and make use of various relational operator to pass the filter condition. You can put a constant value or a list of values in the query filter.

Prompts

They are used to display a question or list of values and are known as dynamic filters.

Filter Condition

Constant option allows you to enter a single value in filter.

List of values allow you to choose one value from all the available values for an object.

Prompt is used to pass dynamic value to a query filter.

Query Panel

OptionDescription
Constant
  • Type a value into the text box

LOV
  • In the Prompt(s) dialog box, add members to your list by double-clicking them, or by selecting them in the Members pane and clicking the arrow in the center

  • Click ok

Prompt
  • In the Edit Prompt dialog box, select New Prompt to add a new prompt, or Use Universe Parameters to select a parameter from your universe

  • If you selected a New Prompt, enter prompt options, or if you selected Use Universe Parameters, select a parameter

  • Click ok

Query Filter Condition


See All

Comments (344 Comments)

Submit Your Comment

See All Posts

Related Posts

SAP Crytal Report / Blog

What is Crystal Reports ?

SAP Crystal Reports is a Business Intelligence tool which is used to generate reports from both SAP and non-SAP data sources. It enables end users to generate reports that includes exceptional visualizations and implement new business requirements into reports to reduce dependency on IT and Report developers.
7-Feb-2022 /17 /344

SAP Crytal Report / Blog

What is GUI Navigation in Crystal Reports?

Crystal Reports for enterprise provides an interface that enables you to quickly and easily create, format, and publish effective reports. The menu bar provides full range of features available in Crystal Reports for Enterprise as shown in the following image.
7-Feb-2022 /17 /344

SAP Crytal Report / Blog

What is Options in Crystal Reports?

Report Options is one of the most commonly used feature in Crystal Report Designer, when you need to access/modify the values of Report Options of a Crystal report at runtime in a Crystal Reports .NET application.
7-Feb-2022 /17 /344