fyiReporting Software, LLC
How to Create a Label Report
The following steps show how to create a report for labels (e.g. Avery labels). This is also known as a multi-column report.
-
Create a list style report using the new report wizard
picking the fields you want on the label.
- When the wizard finishes delete the report items in the page header and page footer. You should also size the height of the empty page header and footer to get the correct page spacing.
- Move the fields into the locations you want to see them on the label. You may want to create Textbox report items with expressions to put fields together (e.g. =Fields!FirstName.Value + " " + Fields!LastName.Value)
-
Bring up the report properties dialog by
clicking on the right mouse button on an empty area below the page footer.
- Adjust the report width to the width of the label on the Report tab.
-
On the Body tab set the Body height to the height of the label plus the height of the vertical gap (if any) between the labels. - Set the # of columns to the number of labels horizontally.
- Set the column spacing to the width of the gap between the labels horizontally (if any).
The final report should look something like the following.
See the example ThreeColumns.rdl for a simple multi-column report.