Hello friends
I have created 2 reportsin Oracle 10g Discoverer . One of which looks like below
Asset item Opening Balance Additions Decuctions Closing Balance
Item 1
3 0 2 1
Item 2
4 0 3 1
Item 3
5 0 4 1
Total (Item 4)
12 0 9 3
In other report item 4 (i.e 3) needs to be subtracted from item 6.And whatever value is shown in the above table is directly reflected in that form. So if any one record value is changed in the above report it will automatically effect the below report
Details Balance
Item 6 7
Item 4 3
Item 7 5
So actually the output is expected to be 7-3+5=9
But in the report it is not recognising item 4 as negative and aggregating all the items and displaying the reult as 7+3+5=15
So my report is wrong
What I have done is made all the data of closing balance in database as negative.And its working. But the report shows negative vvalue which is not approved by my boss.Is there anyway i can store the data as it is (i.e as positive value) and when i show report it should recognize that item 4 needs to be negated thus making my report sensible. Pls help me out in this
Regards