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

Report message to a moderator

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: 21808
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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 21:32:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.