Substring Search

Substring Search

Posted by: ashna.asif on 2 September 2019, 10:40 pm EST

• 

  ashna.asif

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 2 September 2019, 10:40 pm EST

  Hi,

  I have a array of strings.
  
  I want to perform an substring search in that array.
  
  array is ```
  
  Join(Parameters!ChartTable.Value, “,”)

  Example :
  

  IIF( condition, True, False)

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 2 September 2019, 11:02 pm EST

  Hello Ashna,

  Please use the following expression:
  
  =IIF((Join( [@ReportParameter1] , “,”).Contains(“test2”),True,False)

  Also, please refer to the attached report.

  Thanks.
  
  rpt_Containms.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 2 September 2019, 11:02 pm EST

  Hello Ashna,

  Please use the following expression:
  
  =IIF((Join( [@ReportParameter1] , “,”).Contains(“test2”),True,False)

  Also, please refer to the attached report.

  Thanks.
  
  rpt_Containms.zip

• 

  ashna.asif

  • Post Options:
  • Link
    Copy

  Posted 2 September 2019, 11:25 pm EST - Updated 30 September 2022, 6:05 am EST

  Thanks for the solution.
  
  Where can I find these functions. Can you provide me some documentation to refer.

• 

  ashna.asif

  • Post Options:
  • Link
    Copy

  Posted 2 September 2019, 11:25 pm EST

  Thanks for the solution.
  
  Where can I find these functions. Can you provide me some documentation to refer.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 2 September 2019, 11:29 pm EST

  Hello Ashna,

  These are the common Vb function which can be used in the AR Expression. However, you can refer to the following documentation links:
  
  https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#Expressions.html
  
  https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#CommonValues.html
  
  https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#CommonFunctions.html
  
  https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#LookupSetFunctioninDataRegions.html

  Hope it helps.

  Thanks.