Home » Developer & Programmer » Reports & Discoverer » how can i remove -ve value in report
how can i remove -ve value in report [message #244136] Mon, 11 June 2007 12:43 Go to next message
nipun_faq
Messages: 2
Registered: June 2007
Location: delhi
Junior Member

how can i remove the -ve value when m doing this supply_qty-aggrementd_qty then some -ve value also come when m using format trigger for removing this then grand total not come only one frame value come ok plz help
Re: how can i remove -ve value in report [message #244171 is a reply to message #244136] Mon, 11 June 2007 16:33 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, use punctuation. The sentence (if it is called a sentence) is unreadable and hardly understandable the way you've written it. I must admit that I have no idea what you are talking about.
Re: how can i remove -ve value in report [message #244414 is a reply to message #244171] Tue, 12 June 2007 13:11 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi,
Please do some formatting as suggested by LF. You can use abs function and others functions are also available if you did not not want negative value.

Ashu
Re: how can i remove -ve value in report [message #356947 is a reply to message #244414] Mon, 03 November 2008 05:47 Go to previous messageGo to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Hi,

I am using "abs" function to avoid negative figure while printing. However, If the value is -ve, I would like to show within bracket.

For example -1234.44 should print (1234.44)

Any idea?
ILANGO


Re: how can i remove -ve value in report [message #356974 is a reply to message #356947] Mon, 03 November 2008 06:42 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Write your own report formula column; it should return a CHARACTER (bracket + numbers + bracket). Depending on a number sign, return either a (formatted?) number or bracket-enclosed-string.
Re: how can i remove -ve value in report [message #357015 is a reply to message #244136] Mon, 03 November 2008 09:36 Go to previous message
dillango
Messages: 145
Registered: January 2008
Senior Member
It is good idea. But I have to use two column, one is for printing purpose and another for summary.

In Crystal reports, it has the in built facility to print the negative figure within bracket.

Hope Oracle report's next release will have this facility.

ILANGO


Previous Topic: DDE command problem
Next Topic: To remove empty space
Goto Forum:
  


Current Time: Sun Dec 04 02:43:41 CST 2016

Total time taken to generate the page: 0.04302 seconds