IIF(InStr) function - Inserting data into unrelated field

reporting-services reportbuilder
snejsnej picture snejsnej · Mar 31, 2015 · Viewed 14.6k times · Source

I have the following expression in a report field (Report Builder 1.0):

=IIf(InStr(Fields!AMA_WEBUSERID.Value,"support") > 0, Fields!Centre.Value = "Web", Fields!Centre.Value)

The expression evaluates to True, but another field (Centre) is not filled with the string Web. Instead it just says False.

Answer

Chris Latta picture Chris Latta · Mar 31, 2015

You are getting False because the when AMA_WEBUSERID contains "support" you evaluate the Boolean expression Fields!Centre.Value = "Web" which returns False. You can't assign the value of a field in the way you are trying to. Instead, use the following formula for the Value property of the cell where you are displaying the field Centre:

=IIf(InStr(Fields!AMA_WEBUSERID.Value,"support") > 0, "Web", Fields!Centre.Value)

Related questions

Carrying out a SUMIF like operation using SQL Server Report Builder

I'm trying to produce a conditional sum in SQL Server Report Builder 3.0. My expression looks like this: =Sum(Iif(Fields!ProjectTypeID.Value=2,Fields!kWp.Value,0)) I'd hoped that this expression would produce a sum of the kWp of all projects …

Read More
How do I make wildcards work in a like operator in SQL Server reporting services?

I have added a filter expression using the like operator. What do I put in the value field? my parameter is named @test and I'd like the filter to function as a like %@test% would in SQL. I want it …

Read More
Report Builder 3.0: How to convert string representation of dates in mm/dd/yy format using CDate

I'm building a report using Report Builder 3.0. The source system I'm working with has strings representing dates in the format of mm/dd/yy, but I want to show this to the end users as dd-MMM-yy instead. Using CDate on …

Read More