Good Morning,
I have a report that I run based off of a query that I want to have sorted by each employee.
Supervisors go into my database, and fill in a form for each employee which relates to how they do on their calls in the call center. Each employee gets reviewed on 5 random calls. The Supervisors go in and complete the form for 5 calls which then gets placed into a table. I run a query, which asks for the 'Pay Period' that I want to view the 5 MSG Reviews for. This brings me a list of ALL employees that have 5 MSG Reviews for that pay period in one list/view.
I want to run a report that will have all 5 MSG Review calls for each employee but on one page. Said differently, when I run the report, I'll get the employees name at the top, their 5 call reviews and then the next page will have the next employee and their 5 calls etc.
Right now, if I run my report the way I have it set up, it places the first employees name at the top and then blends all of the query results together without creating a page break and a new employee name on the next page.
I have attached 3 samples. One that shows my report design, one that shows the first page of my report, and one that shows the second page.
The first employees 4 calls are on the first page, his last call is on the second page and then the employees who's other calls are on page 2 doesn't reflect their name...
I'm probably making this more difficult than it has to be. Any ideas?
I have a report that I run based off of a query that I want to have sorted by each employee.
Supervisors go into my database, and fill in a form for each employee which relates to how they do on their calls in the call center. Each employee gets reviewed on 5 random calls. The Supervisors go in and complete the form for 5 calls which then gets placed into a table. I run a query, which asks for the 'Pay Period' that I want to view the 5 MSG Reviews for. This brings me a list of ALL employees that have 5 MSG Reviews for that pay period in one list/view.
I want to run a report that will have all 5 MSG Review calls for each employee but on one page. Said differently, when I run the report, I'll get the employees name at the top, their 5 call reviews and then the next page will have the next employee and their 5 calls etc.
Right now, if I run my report the way I have it set up, it places the first employees name at the top and then blends all of the query results together without creating a page break and a new employee name on the next page.
I have attached 3 samples. One that shows my report design, one that shows the first page of my report, and one that shows the second page.
The first employees 4 calls are on the first page, his last call is on the second page and then the employees who's other calls are on page 2 doesn't reflect their name...
I'm probably making this more difficult than it has to be. Any ideas?
