Ron in NYC
Registered User.
- Local time
- Today, 07:56
- Joined
- Mar 4, 2016
- Messages
- 30
I designing a report that gets its data from a query.
The query is a simple join of two tables: one with staff IDs and demographics, and one with Staff IDs, pay date, project, and percent of time allocated to that project. There are 1 to 5 records per employee per pay date.
When I run the query the data are fine. I can filter for an individual, see all their payrolls, allocations and percentages. I can see they're correct in the query. The percentages add up to 100% for any given payroll.
The purpose of the report is to anlayze how people are charging their time. It's grouped a follows:
1, Location (City), header, no footer, no sorting.
2, Emp type (PT or FT), header, sorted decending, no footer
3, Emp Last name, header, sort ascending, no footer
4, Payroll date, header, sort ascending, footer with totals for perencts
Detail row has Project and Percent. The payroll total should always be 100.
What I get:
A report that groups properly on Location and Last, but doesn't include all the payroll dates, and includes all records from other payrolls and groups them with another.
One person who is in 5 payrolls, shows up with the first and the last PR, with 4 records included in the first payroll and a total of 400%, and one record for the latest PR. There are 5 records in the query, with 5 different dates (this employee happens to charge 100% of his time to one project). In the query this person has 5 records, with 5 dates...
The query is a simple join of two tables: one with staff IDs and demographics, and one with Staff IDs, pay date, project, and percent of time allocated to that project. There are 1 to 5 records per employee per pay date.
When I run the query the data are fine. I can filter for an individual, see all their payrolls, allocations and percentages. I can see they're correct in the query. The percentages add up to 100% for any given payroll.
The purpose of the report is to anlayze how people are charging their time. It's grouped a follows:
1, Location (City), header, no footer, no sorting.
2, Emp type (PT or FT), header, sorted decending, no footer
3, Emp Last name, header, sort ascending, no footer
4, Payroll date, header, sort ascending, footer with totals for perencts
Detail row has Project and Percent. The payroll total should always be 100.
What I get:
A report that groups properly on Location and Last, but doesn't include all the payroll dates, and includes all records from other payrolls and groups them with another.
One person who is in 5 payrolls, shows up with the first and the last PR, with 4 records included in the first payroll and a total of 400%, and one record for the latest PR. There are 5 records in the query, with 5 different dates (this employee happens to charge 100% of his time to one project). In the query this person has 5 records, with 5 dates...
Last edited:
