OraFAQ Forum: Reports & Discoverer » Append txt to field

Home » Developer & Programmer » Reports & Discoverer » Append txt to field

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Append txt to field [message #158845]

Tue, 14 February 2006 12:32

sikorsky05
Messages: 40
Registered: October 2005

Member

I am working in a report that has no room to add another text field..
What I want to do is Append the word Rejected after a text field which is already within the report.
Ex: The txt fields displays log 1 comment section for DOC. from source
TASK_DESC.. What I want to do is Append the work
REJECTED After the txt field so it will look like this

log 1 comment section for DOC.REJECTED...

Rejected is from source Doc_STATUS...
is there anyway to do this ... I want to display rejected only for values that have Rejected assigned to it .

Thanks

Using forms 6i

Report message to a moderator

Re: Append txt to field [message #158882 is a reply to message #158845]

Tue, 14 February 2006 22:05

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

HI sikorsky05

why dont you change your query like this

SELECT
DECODE(Doc_STATUS,'REJECETED',TASK_DESC||DOC_STATUS,TASK_DESK)TASK_DESC
FROM YOUR_TABLE

Rgds
Atul p

Report message to a moderator

Previous Topic:	Any nice book for Oracle Reports 6i?????
Next Topic:	Conversion Utility

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 19 05:12:33 CST 2025