?
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
Medium Priority
?
296 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 22618104
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
ID: 22618273
Thank you for your response. I suspected as much, but wanted to exhaust all my options before going that route.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

752 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