D
Dedrie
I have a report that is grouped by EmployeeID; then should list:
Employee Name (once)
Then details of their travel.
Ideally it would look like:
Travel Report for: Employee Name
Date of Travel Number of Days State Visited
01/01/2005 3 AZ
01/15/2005 2 PA
01/27/2005 1 NY
pagebreak
Travel Report for: Employee Name (next employee in database)
Date of Travel Number of Days State Visited
01/01/2005 2 CA
01/15/2005 1 PA
01/27/2005 3 NC
pagebreak
etc....through the list of employees
Unfortunately right now it looks like:
Travel Report for: Employee Name
page break
Date of Travel Number of Days State Visited
01/01/2005 2 CA
page break
Date of Travel Number of Days State Visited
01/15/2005 1 PA
page break
Date of Travel Number of Days State Visited
01/27/2005 3 NC
pagebreak
Travel Report for: Employee Name (next employee)
page break
Date of Travel Number of Days State Visited
01/01/2005 1 NC
page break
Date of Travel Number of Days State Visited
01/15/2005 2 PA
page break
Date of Travel Number of Days State Visited
01/27/2005 3 AZ
pagebreak
I have grouping set on EmployeeID
I have the field FirstName and LastName in the Employee ID groupheader
Any help you can provide would be appreciated.
Employee Name (once)
Then details of their travel.
Ideally it would look like:
Travel Report for: Employee Name
Date of Travel Number of Days State Visited
01/01/2005 3 AZ
01/15/2005 2 PA
01/27/2005 1 NY
pagebreak
Travel Report for: Employee Name (next employee in database)
Date of Travel Number of Days State Visited
01/01/2005 2 CA
01/15/2005 1 PA
01/27/2005 3 NC
pagebreak
etc....through the list of employees
Unfortunately right now it looks like:
Travel Report for: Employee Name
page break
Date of Travel Number of Days State Visited
01/01/2005 2 CA
page break
Date of Travel Number of Days State Visited
01/15/2005 1 PA
page break
Date of Travel Number of Days State Visited
01/27/2005 3 NC
pagebreak
Travel Report for: Employee Name (next employee)
page break
Date of Travel Number of Days State Visited
01/01/2005 1 NC
page break
Date of Travel Number of Days State Visited
01/15/2005 2 PA
page break
Date of Travel Number of Days State Visited
01/27/2005 3 AZ
pagebreak
I have grouping set on EmployeeID
I have the field FirstName and LastName in the Employee ID groupheader
Any help you can provide would be appreciated.