How in the world do you run an accurate Time Card Report? Any & All Suggestions Welcome!
- posted
18 years ago
How in the world do you run an accurate Time Card Report? Any & All Suggestions Welcome!
Glenn, I use the ActiveReports to run a timecard report, and there is one thing that I don't like about it - the total hours on the report is different than the total you get by adding the individual line's hours on a calculator. It is just a little bit different due to rounding.
On each indidivual line (one line representing one punch in time and it's corresponding punch out time), the total hours is computed using the SQL formula:
cast(datediff(second, timein, timeout) as float) / 3600
rather than adding each one of these results together as a sum, it appears that the grand total for the report is computed the same way, by adding together all the timein values, also adding together all the timeout values, and then plugging these numbers in the above datediff formula to get the total hours for the report.
this yields a different result than taking each individual line's hours and adding them together, due to rounding.
is there any way around this?
kevin
There's a time card report under Utilities/Crystal Reports, but it's not very flexible.
There's an Active Report on the Reports Library of Customer Source that usually works better.
If you already have those, what are you finding inaccurate?
Elizabeth would you mind sharing this?
Thanks, Kevin
"Elizabeth" wrote:
I have used Elizabeth's Access report and I can say it looks quite nice, very simple and easy to use. Just a note I did have to change the location of where the tables pointed to but once I did that, smooth sailing.
Rob
We made a report that uses Access to define the hours.
Kevin, If you post your email, I'll be glad to. The discussion posting won't allow the file attachment because of the size. Or you can email me at snipped-for-privacy@stepahead-educational.com
Thanks.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.