Break 1 record in 2
I'm using Crystal Reports 2008 with SQL 2005.
I have a table with some records containing startdate and enddate. What I need is the following:
I need to calculate how many days in a month an event occured.
"disk failure" from 01/02/09 to 10/02/09
disk failure - 10 days in February
but if I have:
"disk failure" from 21/04/09 to 05/05/09
disk failure - 10 days in april
disk failure - 5 days in may
Can Anyone help me?
Daniel de Sousa
Layne Botterill replied
I have tried something similar in Crystal v10 and this is what worked for me:
1. group your data by date (perhaps start date will work)
2. change your group options to print the section for 'every month'
3. to determine a time period, I inserted two summaries; one to determine a minumum and another to determine a maximum, then find the difference between the two to get a period within the month. You have a start and end date so this step may be different from what you need.
Not sure how this would look in a different version of Crystal, but a similar method might exist in 2008.