Conditional Action in SSRS

reporting-services ssrs-2008 iif-function iif
Jesse picture Jesse · Mar 17, 2010 · Viewed 18.5k times · Source

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?

Answer

Jesse picture Jesse · Mar 17, 2010

The null keyword in VB is Nothing:

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

Related questions

SSRS Conditional Formatting Switch or IIF

I currently have the following 2008 SSRS Report and I want to conditionally format background of the columns based on some logic. I have three columns and two of which I would like to change the background color. Columns "Current Risk …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More