Horizontal Report Formatting

[bgwool]

I have a report that currently displays like this:

Employee ID Date Hours Worked Overtime
Joe 7/15 5.3 0
7/17 4.4 0
7/18 6.2 0
7/19 5.5 0

Total = 21.2 Overtime = 0



Mike 7/16 4.9 0
7/17 6.2 0
7/18 7.1 0
7/19 4.3 0

Total = 22.5 Overtime = 0
etc.....

I need it to display horizontally, like this:

Joe 7/15 7/16 7/17 7/18 7/19 etc
5.3 0 4.4 6.2 5.5

Total = 21.2 Overtime = 0
Mike 7/15 7/16 7/17 7/18 7/19 etc.
0 4.9 6.2 7.1 4.3

Total = 22.5 Overtime = 0
....

I tried doing this with a report based on a cross-tab query, but it cuts the report off after ~15 date entries (at the page end, I think). Also, I can create a total value in the cross-tab query, but the report insists on placing it in line with the daily totals instead of letting me put it as a footer on the employee's name. Any help would be appreciated!

(sorry about the formatting, hopefully it is clear how I would like the data displayed)

Thank you -
Nick

[June7]

I've never built a report based on CROSSTAB, I haven't needed CROSSTABs in my dbs. I know they can be difficult. If you want to provide db for analysis, follow instructions at bottom of my post.

EDIT: I actually have one report based on CROSSTAB, wasn't easy.

[bgwool]

Here is a copy of the DB. I removed last names as per request. Thank you very much for the help!

[June7]

Dynamic parameter input popup prompts are just so annoying. Better to use unbound controls on a form and reference them as the inputs.

I tried opening both of the crosstab reports and get slammed with 4 input popups. I enter some dates that I see from the TimeCards table, get error message and report fails to open.

I never use query input popups and I NEVER use dynamic parameterized queries. I use VBA code to build filter criteria and apply to form or report. However, I understand the VBA approach might not work with CROSSTAB.

[bgwool]

Yes, I've been having trouble with that as well. I will try to create a form where the user can input the start and end dates to filter the query/report. Thanks for the help so far. I will probably end up posting here to get help referencing the form controls in the queries. I will also re-post after I fix these issues.

[June7]

I have needed to 'pivot' data where CROSSTAB could not meet my needs. Review: http://forums.aspfree.com/microsoft-...ry-322123.html

More info on crosstabs
http://allenbrowne.com/ser-67.html
http://www.access.hookom.net/Dynamic...rosstabRpt.htm