Tutorial Gateway

  • C
  • C#
  • Python
  • SQL
  • Java
  • JS
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs
  • MySQL

Filters at Tablix Level in SSRS

In SQL Server Reporting Services, Filters are similar to SQL WHERE Clause. Filters are used to restrict the Records displayed by the Report. SSRS supports two types of Filters: Filters at Tablix Level and Filters at Dataset Level.

In this article, we will show you how to filter the data at the Table level (or tablix level) in SSRS(SQL Server Reporting Services) with an example.

TIP: It is always better to apply filters at the Tablix level only. Because it will only apply to this table rather than all the tables using that Dataset.

We are going to use the below-shown report to explain, SSRS filtering the data at the Table level or Tablix level. Please refer to Table Report article to understand the Shared Data Source and Dataset we used for this report. If you observe the below screenshot, It was a normal report with Product Name, Color, Sales Amount, and Tax Amount columns.

Filters at Table Level in SSRS 2014

If you observe the above screenshot, it is displaying the 1373 pages of data.

Filters at Tablix Level in SSRS

To filter data at the table level, Please Select the Top Left Corner of the report, and Right-click on it will open the context menu. Please select the Tablix Properties.. option from it

Filters at Table Level in SSRS 1

Once we click on the Tablix Properties.. option, a new Tablix Properties window will be opened. Please select the Filters tab.

Filters at Tablix Level in SSRS 2

Click on the Add button will display the below properties

  • Expression: It will allow you to select the available Column from the Dataset or we can create an Expression by clicking the fx button
  • Data Type: By default, Text selected as Data type. You can change as per your requirement.
  • Operator: Please select the operator, if you want to use (Like, <, <= etc.)
  • Value: Please specify the value you want to check against the Expression. Please click on the fx button to write value Expression.
Filters at Tablix Level in SSRS 3

In this SSRS Filters at Tablix Level example, We are going to display the records whose [Sales Amount] is Greater than or Equal to 3500. So, Please select the [Sales Amount] as Expression and Operator as >= and Value as 3500.

Filters at Tablix Level in SSRS 4

Here, [Sales Amount] is Float value so, We have to convert 3500 toa Decimal value. If you know the conversion function, you can directly write it. If not, please click on the fx button and use the built-in functions

Filters at Tablix Level in SSRS 5

Click the Ok button to finish writing the Value Expression.

Filters at Tablix Level in SSRS 6

Click the Ok button to finish configuring Filters at Tablix Level in SSRS. Let us Preview the Report

Filters at Tablix Level in SSRS 8

If you observe the above screenshot, it is displaying the 36 pages of data because the remaining data is not satisfying the Filter Condition.

If you want to delete the unnecessary Filter, Please select the SSRS Tablix Filter and click on the Delete button

Filters at Tablix Level in SSRS 8

Filed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021· All Rights Reserved by Suresh.
About | Contact | Privacy Policy