Search results for query: *

Hello, I am using Business Objects Enterprise 11 to schedule some of my crystal reports X1. My reports are failing and I get this error Message. I am facing this issue only for my Scheduled reports and not when I run manually. Operating system file operation on file XXXXXXXX.rpt failed. Can...

Sorry! Crystal Reports XI is the version I am using. I had to compare the next field of ({HPD_HELP_DESK.INCIDENT_NUMBER} and {@Analyst} to make sure that there is no duplicate count. so I am using NEXT function in the formula. please let me know if there is an easier way to do .. Thank you

Hello, I am stuck in the formula mentioned below. I have "Resolved" and "Touched" formulas doing a running total. What I need to do is to combine both in one formula and do a count. Also, field {HPD_HELP_DESK.INCIDENT_NUMBER} should not be counted twice (like one in Resolved and one in...

Thank you both! It worked

Hello, I am using the formulas to do a count based on the condition below. The issue is on the last record, if the condition is true, it displays nothing on the detail section and at the group footer it doesn't count the last record. I undersatand it is because I am using "Next" in my formula...

I tried the below formula {HPD_Help_Desk.Reported_Date} > Today - (DayOfWeek (Today,crSunday) - 1) - 22 and {HPD_Help_Desk.Reported_Date} < Today - (DayOfWeek (Today,crSunday) - 1) It works now. Thank you again

Thank you both Gary and Ian! I used the formula as you said, {HPD_Help_Desk.Reported_Date} >= Today - (DayOfWeek (Today,crSunday) - 1) - 22 and {HPD_Help_Desk.Reported_Date} <= Today - (DayOfWeek (Today,crSunday) - 1) As of today , 3/18/2009 (Thursday) the output I got is starting from...

Thank you so much for replying I tried this formula it doesn't return anything. please assist. Thank you

Hello, How can I filter a report to just show only the last 3 FULL WEEK (not the current week)( SUNDAY - SATURDAY) records? I am using the formula datefield >= dateadd("WW", -3, today) but this includes the data from the current week too because I have startdate = today How can I change the...

Thank you

Thanks again! It works now. But it is in String format, so I couldn't do a sum/average. How can I do that?

Thank You so much for replying! If I use the formula below to convert into minutes, how can I do an average/total of time in Hours and Minutes. Please assist. Thank you DateDiff ("n", {HPD_Help_Desk.Reported_Date}, {HPD_Help_Desk.Last_Resolved_Date})

Hello, I want to find the difference between two dates in hours and minutes. Reported Date: 1/7/2009 3:10:13 PM Resolved Date: 1/7/2009 3:40:50 PM I used the below formula DateDiff ("h", {HPD_Help_Desk.Reported_Date}, {HPD_Help_Desk.Last_Resolved_Date}) It returns 0.00 I want the output as...

Awesome! Works perfectly. Thank you

Hello, How to create a formula and then Group using it. The data I have is 2414 - Detroit West 2437 - Columbus Suburban ------------------------ 2542 - Eau Claire 2543 - Lexington I want to group these two based on the first two charaters of the string. for ex; say I want to group by "24...