Horizonatal Reports [message #88413] |
Tue, 20 August 2002 19:00 |
Rajesh Kumar
Messages: 3 Registered: July 2002
|
Junior Member |
|
|
hi
here is the table structure for storing collection details of different collection agents
for a deposit scheme
coll_agent_no
coll_depo_code
coll_date
coll_amount
coll_mode
total collection amount of different agents will be entered to this table for all
working days.
ie
0A56
CA
01-AUG-2002
24000
C
.
.
.
0A56
CA
20-AUG-2002
12000
C
.......
One of our clients demand is that they need a perodic statement as below
agent 0A56
Date 01-aug-2002 02-AUG-2002 04-AUG-2002 .31-AUG-2002
Amount 24000 18000 17000 11000
For this statement the parameters will be
Agent Code
From date
Till date
Can i design such a report from the above table.(I need to design this report with out
using formula colums for all days)
sincerely
rajesh
|
|
|
Re: Horizonatal Reports [message #88420 is a reply to message #88413] |
Sat, 24 August 2002 01:44 |
Anish Arora
Messages: 3 Registered: September 2000
|
Junior Member |
|
|
u can manipulate ur sql query
if u r using the oracle 8 or 9 u can built ur query
like
select a, b, c, d, e
from
(select coll_agent_no a, coll_depo_code b,coll_date c,
coll_amount d, coll_mode e from table
where
coll_date between '01-jan-02' to '31-jan-01'
union
select coll_agent_no a, coll_depo_code b,coll_date c,
coll_amount d, coll_mode e from table
where
coll_date between '01-feb-02' to '28-feb-02'
)
the above method serves ur purpose but logically its incorrect.
The best method for the above report is to use MATRIX REPORT.....
bye
|
|
|