Using LookupSet in IIF Common Functions

Using LookupSet in IIF Common Functions

Posted by: duonghb53 on 27 July 2021, 9:56 am EST

• 

  duonghb53

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 July 2021, 9:56 am EST

  Dear Support Team
  
  Can I use LookupSet In IIF functions?
  
  Sample I want change color textbox to Red when digit < 0
  
  =IIF(LookUpSet(…) >= 0, “Black”, “Red”)
  
  I use but when digit < 0 it still color Black.
  
  Thank you.

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 28 July 2021, 12:06 pm EST

  The LookupSet function can be used in the Value property of the following data regions - Tablix, Table, Classic Chart, BandedList, List and Sparkline as mentioned at the following documentation link -
  
  https://www.grapecity.com/activereportsnet/docs/v15/online/lookup-set-function-in-data-regions.html
  
  It is supposed to be used within a data region.

• 

  duonghb53

  • Post Options:
  • Link
    Copy

  Posted 28 July 2021, 9:30 pm EST - Updated 30 September 2022, 4:35 pm EST

  Dear Abdias Michael
  
  Maybe a litle mistake, I want get Data from LookupSet and using IIF to Set Color for item.
  
  Please view more detail below.
  
  Can I using LookupSet in Appearance Region?
  
  

  

  895×598 70.4 KB

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 29 July 2021, 9:24 am EST

  Is this TextBox inside a data region (eg. Table, Tablix)? Can you please send across your Report for me to look into for better understanding and provide a solution?
  
  Thanks

• 

  duonghb53

  • Post Options:
  • Link
    Copy

  Posted 29 July 2021, 10:00 pm EST

  Dear Abdias Michael
  
  I replace LookupSet by Lookup in function and it worked.
  
  Thank you for your support.