Previous Topic  Next Topic

Edit Filter Control Dialog Box Properties

You can use the Edit Filter Control dialog box to edit a filter control in a report. This topic describes the options in the dialog box.

Control Type

Specifies the type of the filter control.

Select Fields

Specifies the fields to bind to the filter control from the drop-down list. All the selected fields should be of the same data type. You cannot bind the uncomparable data type fields to a single filter control, such as Binary, Blob, Clob, Longvarchar, Longvarbinary, and Varbinary.

The common usage is to select one field, and then based on the field to filter the data of the components created on the same data source as the selected field.

To filter components using different data sources, choose a common field all the data sources contain and select the field in all the data sources one by one.

Customize Initial Values

By default, Server applies all the values of the selected fields in the filter control. You can select this option to customize the value list.

• Fetch Data
  Opens the Fetch Data dialog box to select values from the database and adds the selected values to the text box below.
• Text box
  You can type values directly in the text box. Make sure the accuracy of their formats and values.

  The text box is an editable multi-row plain text box. It supports general text editing operations including copy, paste, cut, backspace, delete, etc. You can press the Enter key on the keyboard to start a new row. Each row is a value of the user defined value list.

  When you have selected Customize Initial Values but the text box is empty, Server will apply all the values of the selected fields in the filter control.

• 
  Specifies a Date/Time value in the text box.

Link to Other Filters

Specifies whether other on-screen filters that apply to the same data components as the filter control can affect the filter control. For the case of one filter using a business view and another using a query, if the business view contains the query definition, Server also interlinks the two filter controls.

• Example of other filters

  When:

  • Filter1 is applied to DC1, DC2, and DC3.
  • Filter2 is applied to DC1.
  • Filter3 is applied To DC2.
  • Filter4 is applied to DC2 and DC3.

  The result:

  • For Filter1, other filters are Filter2, Filter3, and Filter4.
  • For Filter2, other filter is Filter1.
  • For Filter3, other filters are Filter1 and Filter4.
  • For Filter4, other filters are Filter1 and Filter3.

• Example of different behaviors when Link to Other Filters is set to true and false

  There are three filter controls and they all apply to a table:

  • FC_Country contains the Country field and Link to Other Filters is true.
  • FC_City contains the City field and Link to Other Filters is true.
  • FC_City1 contains the City field and Link to Other Filters is false.

  When you select USA in FC_Country, Server will gray the cities that do not belong to USA in FC_City while FC_City1 is not affected.

Apply To

Specifies the components to which you want to apply the filter created with the filter control.

OK

Inserts a filter control into the report and closes the dialog box.

Cancel

Cancels the operation and closes the dialog box.

Help

Displays the help document about this feature.

Ignores the setting and closes this dialog box.

Previous Topic  Next Topic