Home » Developer & Programmer » Reports & Discoverer » Report Issue!
Report Issue! [message #202329] Thu, 09 November 2006 02:51 Go to next message
Vaish
Messages: 7
Registered: October 2006
Junior Member
Hello All

I'm Creating a report in Oracle Developer Version 9.0.4.0.33.

I Have a Field which stored alphanumeric values. There is one value which is Stored as "End of Statemen" along with some number.

My problem is i dont want to display "End of Statemen", I want it to display as "End of Statement" Ie correct spelling of STATEMENT. But in the table it stores as "End of Statemen".

How do i format my field in the report, as to whenever the End of Statemen comes, it should display as End of Statement and not End of Statemen?

Any help would be appreciated.

Thanks

Report message to a moderator

Re: Report Issue! [message #202334 is a reply to message #202329] Thu, 09 November 2006 03:14 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Using the DECODE function:

SELECT DECODE(column, 'End of Statemen', 'End of Statement', column)
FROM ...

Report message to a moderator

Re: Report Issue! [message #202356 is a reply to message #202334] Thu, 09 November 2006 05:04 Go to previous message
Vaish
Messages: 7
Registered: October 2006
Junior Member
Thanks that worked.

Report message to a moderator

Previous Topic: Info Reqd
Next Topic: error in inserting a image in a existing report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 08:53:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.