Conditional Action in SSRS

2019-04-21 05:50发布

问题:

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?

回答1:

The null keyword in VB is Nothing:

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