This topic has not yet been rated - Rate this topic

Map Group Properties Dialog Box, Filters

SQL Server 2008 R2

Click Filters on the Map Group Properties dialog box to limit the data specified in the selected group.

Options

Add

Click to add a new filter clause to the list.

Delete

Click to delete the selected filter clause from the list.

Up arrow

Click to move the selected filter up in the list.

Down arrow

Click to move the selected filter down in the list.

Expression

Type or choose the expression to which you want to apply a filter. Click the Expression (fx) button to edit the expression.

Data type

Choose the data type for Value. When possible, choose a data type that matches the data type for Expression.

The values in Expression and Value must evaluate to the same data type. For example, if Expression is set to a field that has the data type System.Int32 and Value is set to 7, from the drop-down list, choose Integer.

If the data type option you need is not in the drop-down list, write an expression to convert the value to the correct data type. For more information, see Filter Equation Examples (Report Builder 3.0 and SSRS).

Operator

Select the operator to use to compare the expression and the value.

Value

Type an expression or value to filter on.

Concepts

Maps (Report Builder 3.0 and SSRS)

Customizing the Data and Display of a Map or Map Layer (Report Builder 3.0 and SSRS)

Filtering, Grouping, and Sorting Data (Report Builder 3.0 and SSRS)

Other Resources

Map Property Dialog Boxes (Report Builder 3.0)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD