labels with group header, detail, group footer sections

[PrometheusLI]

How do I create labels with group header, detail, and footer sections?

Specifically, I want to create labels that contain a "customer name" group
header, products ordered by the customer in the detailed section, and a
footer which contains the total product costs, total paid, and amount due.
All this information can be produced from the query and can be generated in a
non-label report.

However when I try to produce labels (Avery 5164, 3 1/2 x 4"), each line
starts a new label, rather than all being printed on the same label. How do
I get the information to print on a single label?

 

[NetworkTrade]

well I don't completely follow your explanation; but to get all info to print
on a single label - get all that info into a single record of a
query....that's the key....

 

[Duane Hookom]

Or create a subreport of the information and display it on a main report that
is a label. I assume there is a field or fields that uniquely identify each
label.

 

[Chuck]

How do I create labels with group header, detail, and footer sections?

Specifically, I want to create labels that contain a "customer name" group
header, products ordered by the customer in the detailed section, and a
footer which contains the total product costs, total paid, and amount due.
All this information can be produced from the query and can be generated in a
non-label report.

However when I try to produce labels (Avery 5164, 3 1/2 x 4"), each line
starts a new label, rather than all being printed on the same label. How do
I get the information to print on a single label?

If the "non-label" report will actually fit in a 3 1/2 x 4" space then:

Reports/Label Wizard, select Avery 5164 label.

The Wizard will allow 8 rows of data on the Avery 5164 Label.
After the label report is finished, open it in design mode. You can make some
modifications. You can change front size and type. You can change height and
width of the text boxes and possible add another text box to get you 9 rows of
data.
The Avery 8167 return address label only allows 2 rows of data. I modify mine
to get 3 rows and use a larger font to boot.

Chuck
--

 

[PrometheusLI]

This issue is not one of fitting the information on the label, but how Access
is formating the label.

I wish the "label report" to consist of an OrderId header with the customer
name (1 line), a detailed section listing each product ordered (1-4 lines),
and an OrderID Footer listing the total cost of the order, the amount paid,
and the amount owed (2 lines). All will print on less than the eight lines
of an Avery 5164 label. This structure works fine (with more column data) on
a regular report using the same query as for the label report. (The report
query results in one row for each product.)

For the "label report" I create the first draft of the label using the label
wizard. I then modify the label report by grouping and adding an OrderID
header, a detailed section for each product, and an OrderID footer with the
summed costs information.

This report, when printed, does not result in a seperate label for each
order, as one might expect. Rather, each detailed row prints as a new label.
I could find no way of manipulating the properties of the sections or
groupings to keep everything together on one label. I have concluded that
maybe the problem is with the properties of columns in reports, which seems
to force each new detailed line to a new column, that is, a new label.

 

[PrometheusLI]

I hadn't thought of using a subreport, and will give this a try.

See detail explanation in reply to Chuck.

 

[PrometheusLI]

Using a subreport solved the problem and was straightforward. Thank you

 

[PrometheusLI]

Thank you for the time you have spent on this. I appreciate it.
I found that Duane Hookom's suggestion to use a subreport easily solved the
problem.