Hi All,

I am working on a crystal report that requires multiple OBS units to be passed as a selection parameter. I have handled multi-select selection parameters before using 'in {? }' operator in Crystal Command SQL. However, because multi-select OBS values are passed in a different format (typeID:unitID:typeName:unitName) this construct is not working. I tried using string functions to get just the unit ids from the selection parameter string but to no success.

Any idea, if there is a way to handle multi-select OBS parameter in a report query?

Thank you.

An ideas for Mangesh?

Thanks

How to handle OBS multiselect values in SQL?

Mangesh Gohad Mar 9, 2015 7:35 AM

Hi All,

I am working on a crystal report that requires multiple OBS units to be passed as a selection parameter. I have handled multi-select selection parameters before using 'in {? }' operator in Crystal Command SQL. However, because multi-select OBS values are passed in a different format (typeID:unitID:typeName:unitName) this construct is not working. I tried using string functions to get just the unit ids from the selection parameter string but to no success.

Any idea, if there is a way to handle multi-select OBS parameter in a report query?

Thank you.