Home » Developer & Programmer » Reports & Discoverer » Can't get plus sign to show up in reports. (Forms/Reports/Web.show_document, 10.1.2.3, Linux)
Can't get plus sign to show up in reports. [message #433333] Tue, 01 December 2009 11:45 Go to next message
dlwixon
Messages: 92
Registered: September 2008
Member
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:

From forms:
l_description := replace(:description,chr(35),'poundsign');
l_repstring := ...||'&p_desc='||l_description||...;
web.show_document(l_repstring);

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));
return l_desc;


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

Re: Can't get plus sign to show up in reports. [message #433348 is a reply to message #433333] Tue, 01 December 2009 14:04 Go to previous message
dlwixon
Messages: 92
Registered: September 2008
Member
This issue is resolved.

It turns out I hadn't compiled the latest for version.

The replace with the chr(43) for the + works.
Previous Topic: REP-0108
Next Topic: One parameter with a "IN" clause
Goto Forum:
  


Current Time: Fri Sep 30 15:46:42 CDT 2016

Total time taken to generate the page: 0.16248 seconds