I am trying to create a report that formats some data horizontally instead of vertically, but I'm having a lot of trouble. The default report will display data like this:
Employee Date Hours Overtime
Mike 8.15 4 0
8.16 3.5 0
8.18 7.5 .25
8.19 5 0
___________
20 .25
Dave
8.17 6 0
8.19 5 0
8.22 3 0
___________
15 0
I need it to display like this:
Employee: Mike
Date: 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Hours: 4 3.5 0 7.5 5 etc...
OT: 0 0 0 .25 0 etc...
Total: 20
OT: .25
---------------------------
I have tried to use a pivot chart, but it's sloppy (especially because I need it to be printed & fit on a paper landscaped horizontally.)
I've attached a copy of the DB as an attachment. If anybody gets a chance to look at it, please open the 'Menu' form, click 'Report', try using the date range of 8/16/2014 to 8/31/2014 & click 'Report By Employee'. This will open 2 different items, a pivot chart form and a report.
Any insight is really appreciated. I've been struggling with this for months. Thank you!