• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Crystal Report 10 - Record Selection query prob

brandonb

Diamond Member
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]
)
 
Back
Top