time card reporting

[Tyler Michals]

Hello,

We would like to make a custom report from the time_card table that displays all records for a single month.

First, let me explain how the time_card table is set up. The entire time_card record revolves around a date field called "Week Starts On". This value is always the date on sunday for the current week. Then we have 7 more decimal fields for the days (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, and Saturday). So an employee can open a new time_card record for the week and log that they worked 4.5 hours on Monday in the Monday Decimal field and click submit. They can update their time for the entire week in that same time_card record (Tuesday = 8, Wednesday = 6.5, Thursday = 7, Friday = 6.25). At the end of the work week, the employee will put their time_card record into a "Submitted" state. Then their manager will go in and either "Approve" or "Reject" the employee's time_card record.

Reporting for the month is an issue because the first and last days of the month tend to fall in the middle of a work week

[PeterWiles]

I can't think of any easy way off the top of my head. You would need to break down the data to be only relevant for the specific month.

Is the report summing the information? Or do you actually need to see each entry for each user but only for that month?

If you are just showing a summary, you create create a new table and a script to calculate the summed values for the user/task/product/etc and make an entry. You would then report of this table.

If you just need to display the records regardless if some of the days fall outside the requested month, then you could add an "Week finishes on" field and have it auto calculate by 7 days. You can then run a report to see if either start or finish dates fall within the moth.

Pete

[Madhu80]

One way to do this would be to create Custom charts.

[PeterWiles]

Didn't think of that.

You would still need to break down the data somehow from being 7 days on one entry to being 7 entries to populate the chart but that custom chart could do that.

Pete