How to handle OBS multiselect values in SQL?

Discussion created by MangeshGohad on Mar 9, 2015
Latest reply on Apr 16, 2015 by Catherine Schuman

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.