How do I project multiple future occurrence dates based on a last performed date and interval in Crystal Reports?
Posted on 2008-10-01
Background: I am using Crystal Reports XI against al Oracle database. I have an Equipment tracking database that can provide me, for each piece of equipment, the date an inspection was last performed, and the inspection interval in days relating to the inspection service. Each piece of equipment could have multiple inspection services - such as 30 day, 60 day, etc. inspection.
Using Crystal Reports, I need to be able to show what is projected by month (grouping) to come due over the next 12 months. This value could be a prompt as well.
When looking at the last performed date, I am not addiing the interval "days" to the value, but I am converting that to a month representation, then adding that to the month the last inspection was performed, taking into consideration rolling into future years. So a last performed date of 01-31-2008 with a 30 day/1 month interval will accurately show as being due in February, not March.
Here is my problem. I am able to accurately calculate and report the first occurrence grouped by month-year due. I am not clear on how to approach the subsequent occurrences. If a piece of equipment has a monthly inspection, it needs to be repeated for all the months shown. If I limit the projection to 12 months, I suspect there may be a hard coded solution?
The next due month