To dgillz I have to create a rep

[kalpsv]

To dgillz

I have to create a report with two columns
one column is for amount for the month
one column is from the date the of computeristiaon
to the end of previous month
both accesses the same table and retrieves
data from the same field i.e. {subscription}
when i tried 31.3.2001 to 30.04.2002 the data
retrieved for the month field shows accumulation
from 31.3.2001 instead of 1.4 to 30.4.
kindly help me
i hope i am clear i am using cr of VB 5
thank you in advance

 

[dgillz]

Please post your formulas and lets take a look at them. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[kalpsv]

To dgillz
I used the following formula
and it works fine even if the year moves to next

IF MAXIMUM ({PPFTXN.VOUCHDT}) in date(2002,03,30) TO
date(YEAR(MAXIMUM({PPFTXN.VOUCHDT})),month(MAXIMUM({PPFTXN.VOUCHDT})),01)-1 THEN
0 ELSE
({@subs});
thanks for your immeditate reply

 

[kalpsv]

To dgillz
I used the above formula
it works fine for all the months from 1st April
but it does not take into account data only for the month of january. it leaves the data of january and gives the figure for the remaining eleven months. I cannot use current date because I am selecting a range from VB
i.e. 1.4.2001 to 28-02-2003

IF ({PPFTXN.VOUCHDT}) in date(year({ppftxn.vouchdt}),04,01) to
date(YEAR(MAXIMUM({PPFTXN.VOUCHDT})),month(MAXIMUM({PPFTXN.VOUCHDT})),01)-1 THEN
({@subs});

I am also having another column where the whole of previous year data is being accumulated ( i.e. if the current year
is july 2002 then this column will accumulate date from 1.4.2001 to 31.3.2002.)
with the above formula this column also gets incorrrect data from the month of January onwards till March.
Kindly help me
Thanks in advance.