Multivalue control and reporting (datawarehouse)

Jan 17, 2008 at 3:36 PM
The multivalue control stores values as a string.

Therefore in the datawarehouse each value different user selection is present.
Ex: "Approved", "Investigate" is one value and "Investigate" is another.

Does anyone know how we could report each selected value to appear only as once value in the datawarehouse.