How do I make a report that repeats the same list many times?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I want to make a report to replicate a checklist that I already have.
The format should be:

Checklist
--------------------
Purchase Item:
Item 1
Item 2
Item 3
--------------------
Unpack Item:
Item 1
Item 2
Item 3

etc.

Tried using grouping and sorting to no avail, just gives me an output of

Checklist
-----------------------
Purchase Item
Item 1
Unpack Item
Item 1

Purchase Item
Item 2
....
etc..

there must be a way to achieve the outcome I'm after?
 
Presumably you have 2 tables:
1. A list of steps (records for 'purchase', 'unpack', etc.)
2. A list of items (item1, item2, etc.)

Create a query that uses both tables. In the upper pane of the query design
window, there must be no line joining the 2 tables. This is called a
Cartesian product, and gives you every possible combination of the 2.

Now use this query as the source for your report. In the Sorting And
Grouping dialog (View menu), create a Group Header for the Steps, and put
the items in the Detail section.
 
I only have a table that lists the items. The Titles for the checklist are
of little importance, I don't really want to have to keep a table for them.

Is it possible to un-nest the group headers, so instead of

GroupHeader0
GroupHeader1
Detail
GroupFooter1
GroupFooter0

I could get

GroupHeader0
Detail
GroupFooter0
GroupHeader1
Detail
GroupFooter1
 
I suppose a better example of what I want to print would be one for visiting
a number of people:

Checklist
--------------------
Contact Details
Jim Smith - 123 Blue Street - 02 12345678
Jane Doe - 22 green Street - 24 52314569

Have they been contacted?
-------------------------------
Jim Smith []
Jane Doe []
 
You could do this by inserting a subreport. The subreport can repeat all the
people again under the next heading.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Matt said:
I suppose a better example of what I want to print would be one for
visiting
a number of people:

Checklist
--------------------
Contact Details
Jim Smith - 123 Blue Street - 02 12345678
Jane Doe - 22 green Street - 24 52314569

Have they been contacted?
-------------------------------
Jim Smith []
Jane Doe []





Matt said:
I only have a table that lists the items. The Titles for the checklist
are
of little importance, I don't really want to have to keep a table for
them.

Is it possible to un-nest the group headers, so instead of

GroupHeader0
GroupHeader1
Detail
GroupFooter1
GroupFooter0

I could get

GroupHeader0
Detail
GroupFooter0
GroupHeader1
Detail
GroupFooter1
Click to expand...
Click to expand...
 
Back
Top