How to split a string and fill an int array with the resulted string elements. RSS

• • Reply
  

  direndd

  0 Points

  1 Post

  How to split a string and fill an int array with the resulted string elements.

  Nov 16, 2012 01:13 PM|LINK

  I have a String {?empNoList} which i want to split by the delimiter '_' and the resulted strings should be converted and filled into a numberVar array. Is this possible with Crystal Report.
  
  The string contains a list of employee IDs which is originally int.I want to query the db using these employee numbers and get the result into the crystal report.

  I have tried it upto this
  
  

  numberVar array empNoIntList;
  
  Local NumberVar strLen := {?empNoListLength}
  
  Local NumberVar i;
  
  for i :=  0 to strLen do
  (
      empNoIntList [i] = Split ({?empNoList},"_")
  )

  I am very to Crystal Report and i'm not sure wheher this is possible.It would be a great help if anybody can help me out. 

• • Reply
  

  Ajay2707

  Contributor

  4487 Points

  870 Posts

  Re: How to split a string and fill an int array with the resulted string elements.

  Nov 19, 2012 06:09 AM|LINK

  Hi Direndd,

  Are you print employee id row-by-row? means you want to evaluate it as row -wise .  you use shared variable. In above code replace Local  to shared keyword.

  http://social.msdn.microsoft.com/Forums/en-US/vscrystalreports/thread/a6000db4-cfb4-4d46-8ef7-e4adf97af219

  Also use shared array variable.

  http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=9687

  http://publib.boulder.ibm.com/infocenter/iadthelp/v6r0/index.jsp?topic=/com.businessobjects.integration.eclipse.doc.crdesigner/reportdesigner/crcondeclaringarrayvariablescrystalsyntax.htm

  Please, Mark as Answer if this reply helped you.
  • Marked as answer by Young Yang - MSFT on Dec 09, 2012 01:10 AM