Recent content by cmsgil

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

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

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

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.

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

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

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

What does the "s" represent?

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