question

rcportillo avatar image
rcportillo asked

SSRS 2012 Title Parameter help

I have a drop down that has three selections. If a user selects one of them how do I make the title change base on selection. Only the 1 time is working not the Annual.

For example:

=IIf(Parameters!AWARDTYPE.Value(0) = "1 TIME" or Parameters!AWARDTYPE.Value(0) = "ANNUAL" , "Purchasing Department One Time Purchase Contracts", "Purchasing Department Annual Contract Purchases")

ssrs-2012expressioniifswitch
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
WRBI avatar image
WRBI answered

I've tried your code and sure enough the OR statement isn't getting evaluated.

There are a couple of options, you could use SWITCH() or you could nest another IIF into the false option. Whichever you prefer :D

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.