Skip to Content
0
Former Member
May 18, 2011 at 05:12 PM

Creating a sql contains in Crystal XI

269 Views

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.