Breaking Down Revolving Charges

[johnwms]

The boss just 'cruised thru' and mentioned - "is it possible to break down when the quarterly and semi-annual and annual payments hit, I need to do show forecasting ..."
So, I need some hints. We do bill customers at other than monthly rates, and I think he needs a forecasting of which month those rotating charges/payments will show up. We have a lastbilled and nextbilled date fields which I'll base the formulas around. But how?
Busy with end-of-month first-of-month stuff, but would appreciate any hints as to the direction I could take. CR9.

 

[synapsevampire]

Try posting technical information:

Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[johnwms]

Sorry about the data shortage -
We use CR 9.2; the DB is Access 97 or Platypus5, which uses CR9.

The data is the customer list (some 60-70 fields of cust data), a custrate table (which links the cust to a ratetype and lastbilled and nextbilled dates), and a rate table (which gives the ratetype, ratename and price).

The output will be groups by ratename (qtrly, semi and annual). Then by bill month (Aug, Sept, Oct …) and counted, and subtotaled by ratename. I’ll suppress the detail as I only want the numbers …

DIALUP QTRLY
07/31/05
893
08/28/05
872
09/25/05
991
DIALUP QTRLY TOTAL ……
DIALUP SEMI
07/31/05
351
08/28/05
386
09/25/05
362
DIALUP SEMI TOTAL ….
It seems to work, but, I’m using the “nextbilldate” field as the ‘Group 2 Name’ which is always the first of the month. But rather than get 08/1/2005 or 09/1/2005 I get 07/31/05 and 08/28/05 (which are the last Sunday of the previous month), how come? Why/how can CR change the information that is part of the report?
Thanx
j-