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
rabidba
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
Littlefoot
Messages: 19476
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: Fri Aug 22 07:17:17 CDT 2014

Total time taken to generate the page: 0.09849 seconds