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: *

  1. cmsgil

    How to get the count for the Number of Groups

    I don't need the total number of groups in the report, i need the total number of groups per group.
  2. cmsgil

    How to get the count for the Number of Groups

    I am using Crstal Reports v8.0. I am creating a report where I have to calculate Averages per Day , Week and or Month in one report. The number of Days, weeks or months can vary based on the date search the user selects. I have created three groups from a Date Time fields to one to print for...
  3. cmsgil

    Crystal Reports Time Comparisons and Averages

    Now that I have the time difference per day per package, I am able to show the average time difference per day by creating a running total to average the value at that group level which is date. What I need now is a way to Group the report into Monday through Friday weeks and then show the...
  4. cmsgil

    Crystal Reports Time Comparisons and Averages

    The formula that ended up working was: DateDiff ("n", CDAteTime({vwBoSci_Reports.PGI_Time}), CdateTime(Cstr(TimeValue{vwBoSci_Reports.UpdateDateTime})))) Now I get the difference in minutes.
  5. cmsgil

    Crystal Reports Time Comparisons and Averages

    I have CR version 8.0.1. I have displayed @PGITime and values display correctly as with the other field. I am using a SQL Database the field types are different. The field type of the @PGITime is a varchar while the other field is a type UpdateDateTime (datetime) @PGITime is simple a type...
  6. cmsgil

    Crystal Reports Time Comparisons and Averages

    I suppose the "s" means seconds, so if i wanted the results to be in minutes would I put "m"? Also I tried this and I still get 0.00 Here is what I have: DateDiff ("s", {vwBoSci_Reports.UpdateDateTime},{@PGITime}) Where @PGITime is a formula that converts a text field to a date using this...
  7. cmsgil

    Crystal Reports - Formula for Hour by Hour totals

    I am writing a report that requires that I show hour by hour what type of carton is passing through a system. I have 3 groups, ShipStation, Date, Carton Type. How do I get the report to reflect for example: 7am to 8am - 675 package shipped 8am to 9am - 435 pacakges shipped and so on and so...
  8. cmsgil

    Crystal Reports Time Comparisons and Averages

    I need some help in figuring out how to create a formula that will show the difference between when an "order" was invoiced and shipped. The shipped time is taken from a field in that is mm/dd/yyyy hh:mm:ss and is formatted to show only the time. The invoiced time is the same format. When I...

Part and Inventory Search

Back
Top