XI - problem to create report

[campia]

Hi,

I need to create a report that shows me the solved incidents:
same day
1day-5days
5days-10d
10-15
15-20
+20days

How can I create this kind of report, any idea?

Thanks in advance.
andré

 

[IdoMillet]

Use a Select Case formula that returns the labels above. Then, group on or create a CrossTab using that formula.

Something like

Select Case DateDiff({incident_date}, currentdate)
Case 0: "Same Day"
Case is 1 to 5: "1day-5days"
...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[campia]

I use this formula:

Select Case DateDiff("d",{Object.Creation Date}, {Object.Solved Date})
Case 0
formula="Same Day"
Case 1 to 5
formula="1day-5days"
Case 5 to 10
formula="5days-10days"
Case 10 to 15
formula="10days-15days"
Case 15 to 20
formula="15days-20days"
Case Else
formula="over 20days"
End select

thanks