Using CR 8.5 and SQL database.
My data is laid out as follows, e.g.:
Reference No. Date Added Date Removed
00001 31/12/2002 15/05/2004
00002 01/03/2003 01/07/2004
00003 01/04/2004
00004 01/06/2004 01/09/2004
I'm trying to create a report that looks like this, e.g:
Month Brought Quantity Quantity Net Gain/
(or date) Forward Added Removed Loss
01/01/2004 300 10 -12 -2
01/02/2004 298 22 -15 7
01/03/2004 305 15 -15 0
I'm usually OK with Crystal, and if the data was laid out as a list of gain/loss events with a date attached, I would be fine - just use groups.
I'm stuck on this one though...can anybody point me in the right diection?
Thanks.
My data is laid out as follows, e.g.:
Reference No. Date Added Date Removed
00001 31/12/2002 15/05/2004
00002 01/03/2003 01/07/2004
00003 01/04/2004
00004 01/06/2004 01/09/2004
I'm trying to create a report that looks like this, e.g:
Month Brought Quantity Quantity Net Gain/
(or date) Forward Added Removed Loss
01/01/2004 300 10 -12 -2
01/02/2004 298 22 -15 7
01/03/2004 305 15 -15 0
I'm usually OK with Crystal, and if the data was laid out as a list of gain/loss events with a date attached, I would be fine - just use groups.
I'm stuck on this one though...can anybody point me in the right diection?
Thanks.