SSRS 2008 If Else condition in text box

iif(Parameters!PO_NUMBER.Value = "","","  PO#: " + Parameters!PO_NUMBER.Value)

First "" = Checking if the PO_NUMBER parameter was null.
Second"" = If first "" is null, then fill the text box with blank.
Third " PO#" = If first "" is not null means, if a value has been selected in parameter, then textbox will fill like: PO#: xxxxxxx
Advertisements
By simplemsexchange Posted in SSRS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s