OraFAQ Forum: Reports & Discoverer » Trial Balance Report

Home » Developer & Programmer » Reports & Discoverer » Trial Balance Report

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

Trial Balance Report [message #117944]

Mon, 02 May 2005 01:03

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Using Report6i & Oracle8i

Problem
(Only concern columns Mentioned)

Tbl_AccountHeads
Col_AccountHeadName (pk)
Col_Balance (always show current balance)

Want to make “Trial Balance” out of it.
Simple display both columns.

But I want to give it exactly the same look as of accounting “Trial Balance”.

i.e. want to display
Positive values of Col_Bal in one column
and
Negative values of Col_Bal in other column

Example:-

(Current Report)
Account Head---------Balance
Cash-----------------5000
Sales----------------3000
Purchase-------------(-8000)

(Desire Report)
Account Head------------Debit Balance-----Credit Balance
Cash--------------------5000
Sales-------------------3000
Purchase----------------------------------------(-8000)
Total-------------------8000--------------------8000

Please advise how to do this.

Wishes
Jawad

Report message to a moderator

Re: Trial Balance Report [message #118208 is a reply to message #117944]

Tue, 03 May 2005 11:55

vban2000
Messages: 207
Registered: March 2005

Senior Member

hi, there..

I am not sure how your table structure or your report data model is... but I suppose something like there may work:

SELECT DECODE (SIGN (:p_amt), 1, :p_amt, 0) dr,
DECODE (SIGN (:p_amt), -1, -:p_amt, 0) cr
FROM DUAL

you can try above sql statement in TOAD

where you will subsitute :p_amt as your transaction amount.. either in your sql query or as an fucntion...

regards
Andy

Report message to a moderator

Re: Trial Balance Report [message #118275 is a reply to message #117944]

Wed, 04 May 2005 01:55

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Dear Andy
thanks for your help.
It worked as under:-

select col_a, decode(sign(col1),1,col1,0) positive_value, decode(sign(col1),-1,col1,0) negative_value from your_table;

Wishes
Jawad

Report message to a moderator

Trial Balance Report [message #160642 is a reply to message #118275]

Mon, 27 February 2006 21:16

samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong

Senior Member

In this case suppose i want the trial balance in T-shape what i have to do for that.

Trial Balance should look like this
Name Dr. Balance Name Cr. Balance
Ushman Khan 10000.00 Yunush Khan 10200.00
Mohhamad 200.00
Total 10200.00 10200.00

What i have to do for getting this type of report.

Samit Gandhi

Report message to a moderator

Previous Topic:	how & where define formula in report
Next Topic:	if condition in Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 09:34:28 CDT 2024