how to replace # with blank in WAD and bex for characteristics object

[Former Member]

Hi Experts,

I have issue with here last 20 day's i have characteristics object and it has blank value and i maintained master data record with blank for the particular object when i put display as text in bex query designer level a can get blank value in Report but when i am trying to publish the same to WAD again am getting the same '#' symbol i want to replace the same to blank.

i don't want to change this to all reports i want this only for particular report.

Please help me on this really appreciate once you give any solution.

Thanks

Karthik.M