Sunday, June 24, 2012

How to add a conditional summary filter

While Case statement and if statements work in detail filter, these statements don’t work in summary filter. The way to make it work is use OR statement as below. Please download report sample for detail review.

(?pFilter?='With Filter') AND ([rank] < 3)
OR
(?pFilter?='Without Filter') AND (1=1)

No comments:

Post a Comment