reprts question
Date: Mon, 12 Apr 1999 14:46:22 +0200
Message-ID: <3711EB1D.A3078703_at_delfin.hr>
I'm newcomer to reports, and have following problem: (I use reports 2.5)
table looks like this
number date
D P S
200 12.01
10 0 -10
201 14.01
0 20 20
202 15.02
20 0 -20
AND I have to get a report from date 13.02 to date 31.12 like this:
202 15.02
20 0 -20
----------------------------------------
SUM
20 0 -20
----------------------------------------
SUM till 13.02
10 20 10 (sum of 200 and 201)
THIS HAS TO RUN AGAIN FOR GRUOPS OF numbers so I cant simply put another query in footer, I mean this just for gruop 2xx and it has to be same as for this for gruop 1 and so on...
like:
1
--------------------------------
101 13.02.
30 ...
109 15.02.
40....
--------------------------------
SUM
70
--------------------------------
SUM TILL 13.02
xxxx
2
---------------------------------
202 15.02
20 0 -20
----------------------------------------
SUM
20 0 -20
----------------------------------------
SUM till 13.02
10 20 10 (sum of 200 and 201)
3
---------------------------------
...
I dont know how to do it, canniot use 2 queries!!!
Received on Mon Apr 12 1999 - 14:46:22 CEST