OraFAQ Forum: Reports & Discoverer » Ladger balance ?? urgent

Home » Developer & Programmer » Reports & Discoverer » Ladger balance ?? urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ladger balance ?? urgent [message #206443]

Thu, 30 November 2006 01:40

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

Dear SIr

I have created a report but there is mistak in total

See attached pic.

Attachment: New Picture.bmp
(Size: 1.22MB, Downloaded 1017 times)

[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: 340
Registered: 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

Report message to a moderator

Re: Ladger balance ??plz urgent [message #206479 is a reply to message #206463]

Thu, 30 November 2006 04:29

kamran.it
Messages: 265
Registered: 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: 265
Registered: September 2005
Location: Karachi

Senior Member

I am waiting plz

Report message to a moderator

Re: Ladger balance ??plz urgent [message #206525 is a reply to message #206479]

Thu, 30 November 2006 07:48

ab_trivedi
Messages: 460
Registered: 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

Report message to a moderator

Re: Ladger balance ??plz urgent [message #206630 is a reply to message #206525]

Thu, 30 November 2006 22:19

kamran.it
Messages: 265
Registered: 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: 460
Registered: 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: 29
Registered: 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

Report message to a moderator

Previous Topic:	Connecting to Oracle Reports (9i or higher) to a DB2 database
Next Topic:	Want to order by at run time?but problem is this that i have 2 different datatypes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 23:19:10 CST 2024