Is there any way of having crystal reports xi generate the sql statement for a record select formula that would be something similar to:
history.description like '%Parameter selection 1%' or '%Parameter selection 2%')
We have 1 parameter that we allow multiple selections for that runs against a column in a table that has multiple values separated by a comma. We can't seem to get crystal to generate a correct sql statement where it can break out the parameter selections and create a correct sql statement that would pull back records that satisfy the parameter conditions.