Home » Developer & Programmer » Reports & Discoverer » Ladger balance ?? urgent
Ladger balance ?? urgent Thu, 30 November 2006 01:40
 kamran.it Messages: 265Registered: September 2005 Location: Karachi Senior Member
Dear SIr

I have created a report but there is mistak in total

See attached pic.

[Updated on: Thu, 30 November 2006 05:40]

Report message to a moderator

Re: Ladger balance ?? [message #206463 is a reply to message #206443] Thu, 30 November 2006 03:18
 javed.khan Messages: 340Registered: November 2006 Location: Banglore Senior Member
Dear Kamran,
It seems somhow allready a calculated value as u mentioned the value you calculated from the formula
33180-660=32520
and now you need a grand total(M I Right?) but first tell me what should be the Total ? I presume it 65100 is it Correct? Please Do post ur Query and before posting any of the ScreenShot make sure it is in JPG so that members can download things easily.ur previously sent BMP was of 1.22 MB So it Takes along to Download.

Regards
Jak
Re: Ladger balance ??plz urgent [message #206479 is a reply to message #206463] Thu, 30 November 2006 04:29
 kamran.it Messages: 265Registered: September 2005 Location: Karachi Senior Member

It not proper calculation let me explain.

Actual you see in picture Balance KGS is 33180

When we minus plan kgs 660 balace = 32520
and now again repeating this formula in 2nd row. not right
2nd row balance should be 32520-600=31980 but report getting total is 32580.

this is a problem

[Updated on: Thu, 30 November 2006 05:18]

Report message to a moderator

Re: Ladger balance ??plz urgent [message #206499 is a reply to message #206479] Thu, 30 November 2006 05:39
 kamran.it Messages: 265Registered: September 2005 Location: Karachi Senior Member
I am waiting plz
Re: Ladger balance ??plz urgent [message #206525 is a reply to message #206479] Thu, 30 November 2006 07:48
 ab_trivedi Messages: 460Registered: August 2006 Location: Pune, India Senior Member
hi kamran,

I understand ur problem you have to do some pl/sql to achieve output ... pl send me the rdf i must try ...

bye
Ashu
Re: Ladger balance ??plz urgent [message #206630 is a reply to message #206525] Thu, 30 November 2006 22:19
 kamran.it Messages: 265Registered: September 2005 Location: Karachi Senior Member
Dear Ashu

Please find attached herewith the rdf file

I used this code but row 2 not showing balance , showing null value

```function CF_3Formula return Number is
bal number;
begin
if :cs_row = 1 or :cs_row =0 then
bal:=:cf_2-:cf_1 ;
return (bal);
elsif :cs_row > 1 then
return(bal);
end if;
end;
```

[Updated on: Fri, 01 December 2006 05:58]

Report message to a moderator

Re: Ladger balance ??plz urgent [message #207261 is a reply to message #206630] Mon, 04 December 2006 21:18
 ab_trivedi Messages: 460Registered: August 2006 Location: Pune, India Senior Member
hi Kamran,

I don't have the test data but i am trying creating a dummy table and dat ...

bye
ashu

[Updated on: Mon, 04 December 2006 21:18]

Report message to a moderator

Re: Ladger balance ??plz urgent [message #207273 is a reply to message #206630] Mon, 04 December 2006 22:20
 kkinapps Messages: 29Registered: November 2006 Location: Hyderabad Junior Member
Hi kamran

plz try this code it works
Actually the problem in ur code is(i think) as your declaring a local variable bal it get's declared and posesses null value evrytime the formula column code is called.
So the second return statement return(bal) in your code will definitely return null value so try using a placeholder column instead.

function CF_3Formula return Number is
begin
if :cs_row = 1 or :cs_row =0 then
:bal:=:cf_2-:cf_1 ;
return (:bal);
elsif :cs_row > 1 then
:bal:=:bal-:cf_1;
return(:bal);
end if;
end;

Note:where :bal is a place holder column

Hope this solves ur problem

Bye
KK
Goto Forum:

Current Time: Wed Jun 28 14:29:08 CDT 2017

Total time taken to generate the page: 0.13079 seconds