Menu
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?
772
Using IIF Function in SSRS The report enables a simple matrix with the Sales Territory Name in the row and the Order Year in the column while the TotalDue is in the data area. We are going to add a new field to the report data set to determine if the Order Year is the Max or Current Year.
The First function returns the first value in a set of data after all sorting and filtering have been applied at the specified scope. The First function cannot be used in group filter expressions with anything except the current (default) scope.
The null keyword in VB is Nothing:
=IIf(Fields!MyTextbox.Value = "0", "Report2", Nothing)
86
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
