'Data scrubbing in SSRS

I have a report that reads data from an oracle database.

One of the tables that is used for a parameter appears to have an invalid value in the XML string that is returned from the query.

'box', hexadecimal value 0x10, is an invalid character. Line 1, position 339820

I am trying to scrub at the query level, prior to loading the parameter drop down using this query

select make_code, 
REGEXP_REPLACE(MAKE_TYPE_DESC,'[^ -~]','') as MAKE_TYPE_DESC  
from make_type 
order by MAKE_TYPE_DESC

I only want the decimal characters 32-126 (space to tilde) characters in the results.

If i take the parameter query out of the report, the report runs ok, when i place the parameter query in, the report fails.

I am lost in this process, any help would be appreciated.

EDIT: Added screen shot screen shot of error



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source