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
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: 20900
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 ...
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.
Previous Topic: Info Reqd
Next Topic: error in inserting a image in a existing report
Goto Forum:
  


Current Time: Thu Dec 08 00:08:10 CST 2016

Total time taken to generate the page: 0.06592 seconds