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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.