How To: Labels
Labels are a common report type; they are easily to build in Report Builder, provided you have some patience for some trial and error fiddling around with the Detail report band:
| ð | Create a new report |
| ð | Add a Detail band to the newly created report |
| ð | Resize the Detail band right margin by first selecting the Detail band (left click once on the Detail band - eight red resize boxes will be displayed along the outer edges of the band) and then moving the right side of the Detail band inward to the desired label width: |

| ð | Obviously it would be extremely handy to have a blank sheet of labels that you can measure for the desired label height/width. Remember that the Detail band needs to be large enough to cover the blank space that SURROUNDS each label and not just the printable area of the label itself! |
| ð | The screen cap above shows the resized Detail band. After you've resized the Detail band you can add the desired text/database field information by adding a Frame, and then add the text or database field information. Clean up the information (e.g. remove the frame borders, align the frames into neat columns, etc) and then save the report. |
| ð | Generate the report and print it to a blank piece of paper; place a blank sheet of labels on top of the printed output and hold both sheets together against an overhead light to see if the Detail band needs to be reduced/enlarged in size to properly print onto the label stock. It will take a few tries to get it right, so be patient! |
A sample output from the screen cap shown above (with text and database field information added to the Detail report band) resembled this in the Print Preview screen:

If more space is needed between the labels I would move the right side of the Detail band slightly to the right. If more space is needed horizontally between the labels I would move the bottom side of the Detail band slightly downward, and so on.
* NOTE *
This type of report would not have any other Report Bands added to it; you will be working with only ONE Detail band!