Solved

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

Posted on 2008-10-01
2
289 Views
Last Modified: 2013-11-15
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
0
Comment
Question by:dr10825
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
Comment Utility
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
 

Author Comment

by:dr10825
Comment Utility
Thank you for your response. I suspected as much, but wanted to exhaust all my options before going that route.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now