Report Formatting

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a report that has the following data:
Software Company, Software Title, License Key(s), Total Media, Total License
and Assigned To.
I would like for it to look like this and start on a new page for each new
Software Title:
Software Company
Software Title
License Key(s)
Total Media
Total License
Assigned To:
1.
2.
3.
4.
........

Then page break after everyone it is assinged to....
 
Use Software Title in the sorting and grouping. Add a group header and set
it to page break before the group.
 
That gives me the following:
Adobe
Acrobat 8 Pro
Total License: 2
Assigned To:
Dan Smith
----Next Page----
Adobe
Acrobat 8 Pro
Total License: 2
Assigned To:
Lonna Davis

When what I want is:
Adobe
Acrobat 8 Pro
Total License: 2
Assigned To:
Dan Smith
Lonna Davis
-----Next Page----
Adobe
Acrobat 7 Pro
Total License: 5
Assigned To:
David Lewis
Sally Smith
Jaden Sells
Michael Davis
Gloria Potter
---Next Page---
etc
etc
etc
 
Sort by SoftwareTitle and group by SoftwareTitle using the Report's Sorting
and Grouping Dialog. Add a group header. And a group footer if you want some
type of summation - such as a count of assigned to.

If you want the Assigned to in alphabetic order, add a sort by that field.

In the group header put the controls for
Software Title:
Software Company
Software Title
License Key(s)
Total Media
Total License
plus a label reading "Assigned To:

In the detail section
Put the control for the Assigned To field

In the group header set the Force New Page control to before section.

Post back if you want to add a sequence number to the assigned to lines.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Back
Top