Wildcards in IIf statement expression

• pandersen

  SSC Enthusiast

  Points: 171

  More actions

  April 25, 2008 at 3:43 pm

  #181616

  I'm trying to get the quantity field to be negative on all credit memos (they start with an 'R') using IIf statement, but I can't seem to get the wildcard correct. Here is what I'm trying, but it's not working.

  =IIf(Fields!InvoiceNumber.Value="R%",(Fields!ShipQuantity.Value*-1),Fields!ShipQuantity.Value)

  Any suggestions?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 25, 2008 at 4:28 pm

  #807436

  I believe you need to use "*" in SSRS as it is not SQL, but .net.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question