Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Break 1 record in 2

hi,

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.

like

"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

I need:

disk failure - 10 days in april

disk failure - 5 days in may

Can Anyone help me?

Thanks

Daniel de Sousa

Former Member
Former Member replied

Daniel,

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.

Layne

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question