Take a look at this. It works with couple exceptions I would like to fix.
!. Formatting for justification for Total Hours and Average Rate:
2. A method other than using {REPORT ENTITY STATE COUNT:(ELSS=PunchIn)} to calculate average Rate of Pay because this will not return a correct value if not every employee clocked in that day…
I am open to discuss any option even if I need to rebuild the report. I just threw this together.
… Data > Fields > Date > Group Interval = Date
… View Options > Unselect these values
Show Column Headers
Show Data Headers
Show Filter Headers
Show Row Headers
Show Column Grand Total Header
Review Data > Fields and adjust widths.
Feel free to play with other settings to make it better for your taste
If something goes wrong delete layout file and start from beginning. We’ll store layouts on database on next releases but for now you can find it under [My Documents]\SambaPOS4\Layout\PG_[Report Name]_[Table Name].xml
@gerlandog as I can see from your screen shot you are adding your data to columns. You can try adding them to data area (inside control). Think it as a 3D (cube) grid. Rows will be date, columns will be waiters and numeric data will be inside grid.
IF its 1 hour 15 min it would show 1.25 If its 1 hour 30 min it would show 1.50 If its 18 hours 15 min its 18.25 and so on. I am using easy numbers for reference…