Newbie Q: correct iif syntax

[KCcasey]

Hi,

Complete newbie! I trying to customise the appearance of a couple of reports in MS Reporting Services (sp2) using its capacity to accept VB.NET expressions...

I thought what I wanted to do was ridicously easy, but its not working!

I have a resultset column that is either "EXPORT" or "NZ". Based on that I want to dictate a colour...

I'm using:
=iif((Fields!SalesBranch) is "NZ", "Red", "Orange")

...and only orange is being returned.

Any ideas??

Thanks in advance, Casey.

 

[ThatRickGuy]

IS compares references. = compares values.

=iif((Fields!SalesBranch) = "NZ", "Red", "Orange")

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[KCcasey]

thats great, only thing is that Reporting Services is returning:

"... Operator '=' is not defined for types 'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Field' and 'String'. Use 'Is' operator to compare two reference types."

Any other ideas?

Kind Regards,

Casey.

 

[ThatRickGuy]

LOL, that'll show me for not using option strict

try:
=iif((Fields!SalesBranch).tostring = "NZ", "Red", "Orange")

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[KCcasey]

well, the expression is working fine, thing is its only returning orange.

I've explicitly cast the SalesBranch field as a string, tried surrounding the test criteria in wildcards and still no dice!

I must be missing something obvious...

<sigh>

Regards,

Casey.

 

[ThatRickGuy]

Are you sure (Fields!SalesBranch).tostring is returning "NZ"? Are you sure it's in caps? If not, try (Fields!SalesBranch).tostring.toupper

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.