Home » Developer & Programmer » Reports & Discoverer » Append txt to field
Append txt to field [message #158845] Tue, 14 February 2006 12:32 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 01:15:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.