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!

Register Log in
  • Congratulations derfloh 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: *

  1. dz0k52

    Formula issue in footer

    Absolutely Perfect, Thanks once again Lbass :-)
  2. dz0k52

    Formula issue in footer

    Observation When I rearrange and use the following as my formula, I get the expected "1" when the first record is an EM. When I remove the // to incorporate the rest of the formula the result for the first record changes to "0". whileprintingrecords; numbervar diff:= 0; numbervar cnt; if...
  3. dz0k52

    Formula issue in footer

    Still null on first record. I am trying this: whileprintingrecords; numbervar diff:= 0; numbervar cnt; if {WORKORDER.ACTSTART} >= previous({WORKORDER.ACTFINISH})then diff := DateDiff ("n", previous({WORKORDER.ACTFINISH}),{WORKORDER.ACTSTART})/60; if (onfirstrecord or diff > 0) and...
  4. dz0k52

    Formula issue in footer

    The results in the footer are perfect, I have just one more issue.If the first record of the report is an 'EM', there is no previous record to do a date diff, so it is not counting it. I can't seem to figure out the proper syntax to count the first record if it is an EM. I tried something like...
  5. dz0k52

    Formula issue in footer

    I am using Crystal 8.5 with an Oracle 9 database. I am having trouble with a formula which is carrying data into the footer and casuing my result to be inaccurate. The report groups all records from one peice of equipment for a particular date range of workorders. The first formula is placed in...
  6. dz0k52

    How to use a Parameter to suppress but default all records.

    I figured it out. I used: not ({WORKORDER.LEADCRAFT} like {?Trade}) in the x-2 and defaulted my discreet value to be *. I should have figured it out in the first place ...sorry.
  7. dz0k52

    How to use a Parameter to suppress but default all records.

    I am using Crystal 8.5 with an Oracle 10 database. I have a report which has three parameters a date range, A location field and Leadcraft selection. The leadcraft selection basically says show me all records that contain that leadcraft.This is a parameter which gets used to supress details...
  8. dz0k52

    Sort by formula field with maximum date field.

    ...(availability of machine) if {@new mtbf calculation} <> 0 then {@new mtbf calculation}/({@new mtbf calculation}+ {@average of repair time} )*100 else 0 @ new mtbf calculation: (Simplified Mean Time Between Failure Calculation) if Sum ({@simple wo count}, {WORKORDER.EQNUM}) <> 0 then...
  9. dz0k52

    Sort by formula feild in Group footer.

    ...(availability of machine) if {@new mtbf calculation} <> 0 then {@new mtbf calculation}/({@new mtbf calculation}+ {@average of repair time} )*100 else 0 text @ new mtbf calculation: (Simplified Mean Time Between Failure Calculation) if Sum ({@simple wo count}, {WORKORDER.EQNUM}) <> 0...
  10. dz0k52

    Sort by formula feild in Group footer.

    I am not familiar with using a stored procedure in report writing. Is there a thread(s) or a resource you could recommend? The scope of this seems to be quite complicated. I am selecting on two parameters including a date range and am reporting on averages of many records (including...
  11. dz0k52

    division by zero error with whileprintingrecords function

    Sorry, The second issue (Sort Order) is addressed in this post: http://www.tek-tips.com/viewthread.cfm?qid=1257961&page=1
  12. dz0k52

    Sort by formula feild in Group footer.

    The "previous" function has caused me grief with other formulas. I am having trouble displaying this result in a chart also. I am assuming its also because of the same reason. Do later versions of Crystal address this issue?
  13. dz0k52

    Sort by formula feild in Group footer.

    ...group. if {@Mean time between failure} <> 0 then {@Mean time between failure}/ ({@Mean time between failure}+ {@Avg. Time to Repair} )*100 else 0 This calculation uses the following formulas: @Mean time between failure :average amount of time between workordersThis is also placed in the...
  14. dz0k52

    division by zero error with whileprintingrecords function

    That worked great. Thanks a million. Is there anyway to "order by" the results of the above formula? (Placed in a group footer)
  15. dz0k52

    division by zero error with whileprintingrecords function

    I am using Crystal 8.5 with an Oracle 10 database. I have looked at many threads and cannot figure this one out. I have a formula: WhilePrintingRecords; numbervar sumhrs/({@sum workorders}); that is placed in the group footer to give me an average of records from another formula. It works great...
  16. dz0k52

    Suppress details section with OR statement

    Believe it or not I try records with both suppressions and neither works now.
  17. dz0k52

    Suppress details section with OR statement

    I am using Crystal 8.5 and am having trouble suppressing a details sections with an OR statement. My statement is {WORKORDER.STATUS} <> 'WAITASGN' or {WORKORDER.WO13} <> 'Y' and is placed in the X-2 box of the suppress button. Whichever one is listed first works but not both. What am i doing...
  18. dz0k52

    Show week number across multiple years.

    Thanks again it worked excellent.
  19. dz0k52

    Show week number across multiple years.

    Actually you did follow, perfectly. Could you explain a little about the function you used like what does the 01,01 do, I would really appreciate it.
  20. dz0k52

    Show week number across multiple years.

    I am using Crystal 8.5 with an Oracle 9.0 database.I am trying to show the "week #" of a date in which a task has been scheduled. I have found multiple ways of doing this but I am struggling with dates that span previous or subsquent years. For example a task scheduled for January 13th 2003...

Part and Inventory Search

Back
Top