In Crystal Reports, we have an input parameter which takes a client id, which multiple can be passed in seperated by a comma. So I'm trying to split the input paramater, and create a record selection query based on that. I've created an loop and an if statement to build the SQL statement. However, it's telling me at the OR statement on the last line is not a number, string, boolean error. Is it possible to do what I want to do?
Local NumberVar intl_ITERATOR;
Local StringVar Array strl_NAME := Split({?inpClient}, ",");
For intl_ITERATOR := 0 To UBound(strl_NAME) Do
(
If intl_ITERATOR = 0 Then
{ACCOUNT.CLIENT} = strl_NAME[0]
Else
OR {ACCOUNT.CLIENT} = strl_NAME[intl_ITERATOR]
)