Report Grouping Error

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.
 
M

Marshall Barton

Dedrie said:
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


That effect inplies that you have either set the detail
section's ForceNewPage property to After Section, the detail
section contains a Page Break control, or that the detail
section is too tall to fit more than one on a page.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top