CODEWITHSUNDEEP
reporting-servicesssrs-2008iif-functioniif
Jesse
Jesse

Reputation: 2053

Conditional Action in SSRS

I want my textbox to have an action ONLY if the condition is true, otherwise no action. This is what I have as my current action expression for going to another report:

=IIf(Fields!MyTextbox.Value = "0", "Report2","")

This does not produce my desired result. It gives the textbox an action regardless of the condition result. Is there a 'No Action' or 'Cancel Action' value?

Upvotes: 13

Views: 20437

Answers (1)

Jesse
Jesse

Reputation: 2053

The null keyword in VB is Nothing:

=IIf(Fields!MyTextbox.Value = "0", "Report2", Nothing)

Upvotes: 26

Related Questions