O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding a filter in the dataset

You may want to filter your dataset by an attribute from another dimension, such as the Date dimension. The query designer provides the tools needed to slice and dice the data with multiple dimensions. We may not call the multidimensional model a "cube" if we cannot examine the data in different dimensions.

Let's filter the dataset by the sales amount in the year 2008 only. Normally, we want to test the most recent data but we're ok with the 2008 data for now.

  1. From the report designer, double-click on the dsSalesTerritory dataset.
  2. That displays the Dataset Properties dialog box. Click on the Query Designer button which will load the query designer dialog box.
  3. You can add a filter in two ways:
    • Expand the Date dimension. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required