CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2012ssrs-expression
ivric
ivric

Reputation: 109

filtering SSRS expressions

I have a tablix which has an expression as a Row header and its shows Yr2018-Q1 expression below:

="Yr"&Fields!YEAR.Value & "_Q" & Fields!qtr.Value

I'm trying to show only as far back as Yr2017-Q2 for e.g

enter image description here

currently the tablix show like below:

enter image description here

Upvotes: 0

Views: 140

Answers (1)

McGlothlin
McGlothlin

Reputation: 2099

As Larnu said the best way to do this is filter by a date column if you have it. However, this will only work if you have a way of mapping a quarter to a specific date. If that is not the case, the following should work for your filter expression:

Expression

Switch(Fields!YEAR.Value = Parameters!Year.Value
    And Fields!qtr.Value >= Parameters!Qtr.Value, 1,
    Fields!YEAR.Value > Parameters!Year.Value, 1,   
    1=1, 0
)

Operator

=

Value

1

There is no default case with a switch statement, hence the 1=1, which always evaluates to True.

Upvotes: 2

Related Questions