How do I project multiple future occurrence dates based on a last performed date and interval in Crystal Reports?

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
dr10825Asked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
A record can only appear in one group.
If you want records to appear in multiple groups based on derived due dates then you will have to do something in the database to create those records,  CR is not going to do it.

There is probably an alternative approach using very customised subreports which have specific formulas to deal with particular date groups.  But it would not be straightforward.




0
 
dr10825Author Commented:
Thank you for your response. I suspected as much, but wanted to exhaust all my options before going that route.
0
All Courses

From novice to tech pro — start learning today.