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
292 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
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

Suggested Solutions

Title # Comments Views Activity
Formatting a Crystal Report 2 70
Crystal Report Image from SQL field with file location 3 75
Business Object Server 2 30
Crystal reports filter out records 2 36
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

821 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