Home » Developer & Programmer » Forms » How to print & in Title (forms 10)
How to print & in Title [message #583414] Tue, 30 April 2013 09:53 Go to next message
Messages: 1
Registered: April 2013
Location: Bangalore
Junior Member
How to print ampersand & in Oracle report from the parameter.

If give paramter 'Title of the report Profit & Loss'
it Print:-Title of the report- Profit & Loss

If give paramter Title of the report- Profit & Loss(without single code)
it Print:-Title of the report- Profit

please suggest
Re: How to print & in Title [message #583432 is a reply to message #583414] Tue, 30 April 2013 14:13 Go to previous message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create another user parameter (let's call it PAR_NEW_TITLE, while the original parameter is PAR_TITLE). In After Parameter Form trigger set new title's parameter value to
:PAR_NEW_TITLE := chr(39) || :PAR_TITLE || chr(39);
(chr(39) is a single quote character). Finally, display PAR_NEW_TITLE instead of PAR_TITLE.
Previous Topic: Insert the date and time automatically in table
Next Topic: How do you use a created table in a data block?
Goto Forum:

Current Time: Sun Jul 23 08:18:48 CDT 2017

Total time taken to generate the page: 0.10083 seconds