Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: angel7170
  • Content: Threads
  • Order by date
  1. angel7170

    Error Message: Operating system file operation on file failed

    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...
  2. angel7170

    Running Total Crystal Reports Formula

    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...
  3. angel7170

    NEXT and ONLASTRECORD issue in Crytsal reports

    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...
  4. angel7170

    Calculate only the last 3 FULL Weeks using crystal reports formula

    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...
  5. angel7170

    DateDiff in hours and minutes

    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...
  6. angel7170

    Group based on a formula in Crystal Reports

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

Part and Inventory Search

Back
Top