SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Reporting Services

Technical Reference

Feature Reference

Report Designer in Business Intelligence Development Studio F1 Help

Report Designer F1 Help

Action Properties Dialog Box

Axis Properties Dialog Box, Axis Options

Axis Properties Dialog Box, Line

Axis Properties Dialog Box, Label Font

Axis Properties Dialog Box, Labels

Axis Properties Dialog Box, Major Tick Marks

Axis Properties Dialog Box, Minor Tick Marks

Axis Properties Dialog Box, Number

Axis Properties Dialog Box, Visibility

Axis Title Properties Dialog Box, Font

Axis Title Properties Dialog Box, General

Calculated Series Properties Dialog Box, Axes and Chart Area

Calculated Series Properties Dialog Box, Border

Calculated Series Properties Dialog Box, Fill

Calculated Series Properties Dialog Box, General

Calculated Series Properties Dialog Box, Legend

Calculated Series Properties Dialog Box, Markers

Calculated Series Properties Dialog Box, Shadow

Calculated Series Properties Dialog Box, Visibility

Category Group Properties Dialog Box, Filters

Category Group Properties Dialog Box, General

Category Group Properties Dialog Box, Sorting

Category Group Properties Dialog Box, Variables

Chart Area Properties Dialog Box, 3D Options

Chart Area Properties Dialog Box, Alignment

Chart Area Properties Dialog Box, Border

Chart Area Properties Dialog Box, Fill

Chart Area Properties Dialog Box, Shadow

Chart Area Properties Dialog Box, Visibility

Chart Properties Dialog Box, Border

Chart Properties Dialog Box, Fill

Chart Properties Dialog Box, Filters

Chart Properties Dialog Box, General

Chart Properties Dialog Box, Visibility

Chart Title Properties Dialog Box, Border

Chart Title Properties Dialog Box, Fill

Chart Title Properties Dialog Box, Font

Chart Title Properties Dialog Box, General

Chart Title Properties Dialog Box, Shadow

Chart Title Properties Dialog Box, Visibility

Column Visibility Dialog Box

Convert CRI Dialog Box

Cube Selection Dialog Box

Data Source Properties Dialog Box, Credentials

Data Source Properties Dialog Box, General

Dataset Properties Dialog Box, Fields

Dataset Properties Dialog Box, Filters

Dataset Properties Dialog Box, Options

Dataset Properties Dialog Box, Parameters

Dataset Properties Dialog Box, Query

Define Query Parameters Dialog Box

Delete Columns Dialog Box

Delete Group Dialog Box

Delete Rows Dialog Box

Embedded Images Dialog Box

Enter Data Source Credentials Dialog Box

Expression Dialog Box

Grouping Pane

Gauge Label Properties Dialog Box, Action

Gauge Label Properties Dialog Box, Border

Gauge Label Properties Dialog Box, Fill

Gauge Label Properties Dialog Box, Font

Gauge Label Properties Dialog Box, General

Gauge Label Properties Dialog Box, Shadow

Gauge Panel Group Properties Dialog Box, Filters

Gauge Panel Group Properties Dialog Box, General

Gauge Panel Group Properties Dialog Box, Sorting

Gauge Panel Group Properties Dialog Box, Variables

Gauge Panel Properties Dialog Box, Border

Gauge Panel Properties Dialog Box, Fill

Gauge Panel Properties Dialog Box, Filters

Gauge Panel Properties Dialog Box, General

Gauge Panel Properties Dialog Box, Visibility

Image Properties Dialog Box, Border

Image Properties Dialog Box, General

Image Properties Dialog Box, Size

Image Properties Dialog Box, Visibility

Linear Gauge Properties Dialog Box, Action

Linear Gauge Properties Dialog Box, Back Fill

Linear Gauge Properties Dialog Box, General

Linear Gauge Properties Dialog Box, Frame

Linear Gauge Properties Dialog Box, Frame Border

Linear Gauge Properties Dialog Box, Frame Fill

Linear Gauge Properties Dialog Box, Frame Shadow

Linear Pointer Properties Dialog Box, Action

Linear Pointer Properties Dialog Box, Pointer Border

Linear Pointer Properties Dialog Box, Pointer Fill

Linear Pointer Properties Dialog Box, Pointer Options

Linear Pointer Properties Dialog Box, Shadow

Linear Scale Properties Dialog Box, Action

Linear Scale Properties Dialog Box, Border

Linear Scale Properties Dialog Box, Fill

Linear Scale Properties Dialog Box, General

Linear Scale Properties Dialog Box, Font

Linear Scale Properties Dialog Box, Labels

Linear Scale Properties Dialog Box, Layout

Linear Scale Properties Dialog Box, Major Tick Marks

Linear Scale Properties Dialog Box, Minor Tick Marks

Linear Scale Properties Dialog Box, Number

Linear Scale Properties Dialog Box, Shadow

Linear Scale Range Properties Dialog Box, Action

Linear Scale Range Properties Dialog Box, Border

Linear Scale Range Properties Dialog Box, Fill

Linear Scale Range Properties Dialog Box, General

Linear Scale Range Properties Dialog Box, Shadow

Legend Properties Dialog Box, Border

Legend Properties Dialog Box, Font

Legend Properties Dialog Box, Fill

Legend Properties Dialog Box, General

Legend Properties Dialog Box, Visibility

Legend Properties Dialog Box, Shadow

Legend Title Properties Dialog Box, Font

Legend Title Properties Dialog Box, General

Minor Gridline Properties Dialog Box, Visibility

Minor Gridline Properties Dialog Box, General

Major Gridline Properties Dialog Box, Visibility

Major Gridline Properties Dialog Box, General

Placeholder Properties Dialog Box, Action

Placeholder Properties Dialog Box, Alignment

Placeholder Properties Dialog Box, General

Placeholder Properties Dialog Box, Font

Placeholder Properties Dialog Box, Number

Radial Gauge Properties Dialog Box, Action

Radial Gauge Properties Dialog Box, Back Fill

Radial Gauge Properties Dialog Box, Frame

Radial Gauge Properties Dialog Box, Frame Border

Radial Gauge Properties Dialog Box, Frame Fill

Radial Gauge Properties Dialog Box, Frame Shadow

Radial Gauge Properties Dialog Box, General

Radial Pointer Properties Dialog Box, Action

Radial Pointer Properties Dialog Box, Cap Fill

Radial Pointer Properties Dialog Box, Cap Options

Radial Pointer Properties Dialog Box, Pointer Border

Radial Pointer Properties Dialog Box, Pointer Fill

Radial Pointer Properties Dialog Box, Pointer Options

Radial Pointer Properties Dialog Box, Shadow

Radial Scale Properties Dialog Box, Action

Radial Scale Properties Dialog Box, Border

Radial Scale Properties Dialog Box, Fill

Radial Scale Properties Dialog Box, General

Radial Scale Properties Dialog Box, Labels

Radial Scale Properties Dialog Box, Font

Radial Scale Properties Dialog Box, Layout

Radial Scale Properties Dialog Box, Major Tick Marks

Radial Scale Properties Dialog Box, Minor Tick Marks

Radial Scale Properties Dialog Box, Number

Radial Scale Properties Dialog Box, Shadow

Radial Scale Range Properties Dialog Box, Action

Radial Scale Range Properties Dialog Box, Border

Radial Scale Range Properties Dialog Box, Fill

Radial Scale Range Properties Dialog Box, General

Radial Scale Range Properties Dialog Box, Shadow

Rectangle Properties Dialog Box, Border

Rectangle Properties Dialog Box, Fill

Rectangle Properties Dialog Box, General

Rectangle Properties Dialog Box, Visibility

Report Data Pane

Page Footer Properties Dialog Box, Border

Page Footer Properties Dialog Box, Fill

Page Footer Properties Dialog Box, General

Page Header Properties Dialog Box, Border

Page Header Properties Dialog Box, Fill

Page Header Properties Dialog Box, General

Report Parameter Properties Dialog Box, Advanced

Report Parameter Properties Dialog Box, Available Values

Report Parameter Properties Dialog Box, Default Values

Report Parameter Properties Dialog Box, General

Report Body Properties Dialog Box, Border

Report Body Properties Dialog Box, Fill

Report Properties Dialog Box, Code

Report Properties Dialog Box, Page Setup

Report Properties Dialog Box, References

Report Properties Dialog Box, Variables

Report Sections Dialog Box

Reporting Services Login Dialog Box (SSRS)

Reporting Services Query Designers

Row Visibility Dialog Box

Select Color Dialog Box

Series Group Properties Dialog Box, Filters

Series Group Properties Dialog Box, General

Series Group Properties Dialog Box, Sorting

Series Group Properties Dialog Box, Variables

Series Label Properties Dialog Box, Border

Series Label Properties Dialog Box, Fill

Series Label Properties Dialog Box, Font

Series Label Properties Dialog Box, General

Series Label Properties Dialog Box, Number

Series Label Properties Dialog Box, Visibility

Series Properties Dialog Box, Axes and Chart Area

Series Properties Dialog Box, Border

Series Properties Dialog Box, Fill

Series Properties Dialog Box, Legend

Series Properties Dialog Box, Markers

Series Properties Dialog Box, Series Data

Series Properties Dialog Box, Shadow

Series Properties Dialog Box, Visibility

Shared Data Source Properties Dialog Box, Credentials

Shared Data Source Properties Dialog Box, General

Subreport Properties Dialog Box, Border

Subreport Properties Dialog Box, General

Subreport Properties Dialog Box, Parameters

Subreport Properties Dialog Box, Visibility

Tablix Group Dialog Box

Tablix Group Properties Dialog Box, Advanced

Tablix Group Properties Dialog Box, Filters

Tablix Group Properties Dialog Box, General

Tablix Group Properties Dialog Box, Page Breaks

Tablix Group Properties Dialog Box, Sorting

Tablix Group Properties Dialog Box, Variables

Tablix Group Properties Dialog Box, Visibility

Tablix Properties Dialog Box, Filters

Tablix Properties Dialog Box, General

Tablix Properties Dialog Box, Sorting

Tablix Properties Dialog Box, Visibility

Text Properties Dialog Box, Alignment

Text Properties Dialog Box, Font

Text Properties Dialog Box, General

Text Box Properties Dialog Box, Alignment

Text Box Properties Dialog Box, Border

Text Box Properties Dialog Box, Fill

Text Box Properties Dialog Box, Font

Text Box Properties Dialog Box, General

Text Box Properties Dialog Box, Interactive Sorting

Text Box Properties Dialog Box, Number

Text Box Properties Dialog Box, Visibility

Map Property Dialog Boxes (Report Builder 3.0)

Map Wizard and Map Layer Wizard (Report Builder 3.0 and SSRS)

Minimize

This topic has not yet been rated - Rate this topic

Dataset Properties Dialog Box, Filters

SQL Server 2008 R2

Select Filters on the Dataset Properties dialog box to create filters for the dataset.

Add: Add a new filter clause to the list.
Delete: Delete the selected filter clause from the list.
Up arrow: Move the selected filter up in the list.
Down arrow: 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. For more information, see Filter Equation Examples (Report Builder 3.0 and SSRS).
Operator: Choose the operator to use to compare the expression and the value.
Value: Type the expression or value to use when evaluating the expression specified in the Expression box. Click the Expression (fx) button to edit the expression.

Concepts

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

Adding Data to a Report (Report Builder 3.0 and SSRS)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.