OraFAQ Forum: Reports & Discoverer » How to create account statement without using temp. table

Home » Developer & Programmer » Reports & Discoverer » How to create account statement without using temp. table (

) 1 Vote

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

How to create account statement without using temp. table [message #117906]

Sun, 01 May 2005 05:25

yuv_ora
Messages: 5
Registered: May 2005
Location: Kathamndu

Junior Member

Dear Guru,

I'd always use some temp. teble to first generate requred data in the table and then display it using reports.
But in true multiuser inviornment it gives so many problem. so can anybody help me to create the statement report..
I'v following table..
1. account_history
2. account_transaction

my statement should be look like this

Date Particular Dr. Cr. Balance
01-Apr Previouse Bal. 500Dr.
02-Apr Cash Deposit 500 1000Dr.

so on...

pls. help me....
Thanks and regards
Yuvraj

Report message to a moderator

Re: How to create account statement without using temp. table [message #118632 is a reply to message #117906]

Fri, 06 May 2005 10:20

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Can you give the definition of the two tables?

Report message to a moderator

Re: How to create account statement without using temp. table [message #118724 is a reply to message #118632]

Sat, 07 May 2005 05:53

supportsib
Messages: 3
Registered: April 2005
Location: kuwait

Junior Member

use materialized view

Report message to a moderator

Re: How to create account statement without using temp. table [message #119010 is a reply to message #118724]

Tue, 10 May 2005 05:06

yuv_ora
Messages: 5
Registered: May 2005
Location: Kathamndu

Junior Member

could u pls. give me the example code to create view..

Report message to a moderator

Re: How to create account statement without using temp. table [message #119011 is a reply to message #118632]

Tue, 10 May 2005 05:10

yuv_ora
Messages: 5
Registered: May 2005
Location: Kathamndu

Junior Member

Thanks for reply...
Account_History Table/...

acode varchar2(6),
Hdate date

trans table
Tdate date
acode varchar2(6),
amount number

Report message to a moderator

Re: How to create account statement without using temp. table [message #120131 is a reply to message #117906]

Tue, 17 May 2005 19:47

danosw
Messages: 20
Registered: May 2005
Location: California

Junior Member

Basicly I'd use a union (avoid the DBA) and page break on account number change.
(I assume your doing this in Oracle Reports)

select tdate, amount, description, account from account_transaction where tdate between :p_begin_date and :p_end_date
union all
select hdate, amount, description, account from account_history
where hdate between :p_begin_date and :p_end_date
order by 4,1

Add summary columns.

Dano

Report message to a moderator

Re: How to create account statement without using temp. table [message #121262 is a reply to message #120131]

Fri, 27 May 2005 04:18

satishbkk
Messages: 2
Registered: May 2005
Location: bangkok

Junior Member

Yes i agree with dano ,union all will produce the xact result for

Date Particular Dr. Cr. Balance
01-Apr Previouse Bal. 500Dr.
02-Apr Cash Deposit 500 1000Dr.

Report message to a moderator

Previous Topic:	If i use Graph and image together in Oracle Report9i then Display of Graph is not clear
Next Topic:	Reports & forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 06:43:46 CDT 2024