I'm trying to get the plus sign to show up in reports. I am calling the reports from a form. I'm using web.show_document to call the reports. In order for this to work, I have to use a replace statement in forms to send the parameters to the reports. Then I have to use the replace statement in the reports so that I can get the special characters back in the fields.
Here's an example:
l_description := replace(:description,chr(35),'poundsign');
l_repstring := ...||'&p_desc='||l_description||...;
Where p_desc is a user parameter on the report.
Then in the report I change it back in a cf using the following code:
l_desc := replace(:p_desc,'poundsign',chr(39));
This works fine for the poundsign and other characters but does not work for the plus sign (+) using the ASCII code 43.
I just get a blank space where the + should be.
I've also tried
l_description := replace(:description, 'plussign','+');
but the + still show up as blank on the report.
Anyone know what's going on?
[Updated on: Tue, 01 December 2009 13:26]
Report message to a moderator