I am using Crystal 9.
I have been asked to write a report based on records that have the following data:
charge_amount
tax_amount
charge_date
charge_start_date
Charge_end_date
.
.
.
Some charges are for a single date. When that is true, charge_date is populated. Some charges are for a rental that spans some range of dates. When that is true, the charge_start_date and charge_end_date are populated.
I have been asked to create a report that sorts, by date, the sum of the charges and taxes. So, if the date range is from July 10, 2005 through July 20, 2005, I would take the charge_amount and divide it by the 11 days and get an amount per day. I then need to add this to the sum for each of these days July 10, July 11, July 12, etc. I need to also do this for the tax amount.
I am not sure how to create this array. I will not have any knowledge of the dates of these charges until I am processing the records. I will need to print the totals sorted by date. Ideally, I would have each date drill-down to the individual records I recieved, but I'm not sure if that part is possible.
Can anyone give me help with this? I'm not sure how to create such an array.
Thanks in advance!
Meryl
Thanks very much.
I have been asked to write a report based on records that have the following data:
charge_amount
tax_amount
charge_date
charge_start_date
Charge_end_date
.
.
.
Some charges are for a single date. When that is true, charge_date is populated. Some charges are for a rental that spans some range of dates. When that is true, the charge_start_date and charge_end_date are populated.
I have been asked to create a report that sorts, by date, the sum of the charges and taxes. So, if the date range is from July 10, 2005 through July 20, 2005, I would take the charge_amount and divide it by the 11 days and get an amount per day. I then need to add this to the sum for each of these days July 10, July 11, July 12, etc. I need to also do this for the tax amount.
I am not sure how to create this array. I will not have any knowledge of the dates of these charges until I am processing the records. I will need to print the totals sorted by date. Ideally, I would have each date drill-down to the individual records I recieved, but I'm not sure if that part is possible.
Can anyone give me help with this? I'm not sure how to create such an array.
Thanks in advance!
Meryl
Thanks very much.