IIf and expressions

Comments

• AlexTZ

  February 2010 edited 3:44AM

  Hello,
  
  Both
  [IIf([newpage_groepveld]=="1" , [Table.afroepregels_refentie] , [Table.afroepregels_plantnaam])]
  and
  newpage_groepveld]=="1" ? [Table.afroepregels_refentie] : [Table.afroepregels_plantnaam
  must work. The "newpage_groepveld" report parameter must be of String type. If it is numeric, use ... == 1 instead of ... == "1".
• Hans

  February 2010 edited 3:44AM

  I used this expression at the GroupHeader Band Condition. Here this results in an error CS1525 followed by CS1002.
  
  Is this caused because we using an expression with a "IIf"in a group header?
  BTW, we can use expression like [Table.col1] + [Table.col2], it only fails when we add the "IIf" construction.
  
  
• AlexTZ

  February 2010 edited 3:44AM

  In this case you don't need outer brackets:
  IIf([newpage_groepveld]=="1" , [Table.afroepregels_refentie] , [Table.afroepregels_plantnaam])
  (they are needed if you print this in the Text object).