Records Per Item Example

You can use the Records Per Item property page of the Database Setup dialog to print multiple database records on a single printed item and to specify how you want those records to be grouped on your printed items.

Consider the following example:

You have a text database that is called Products.txt. It contains thirteen records that consist of products and the region from which the product originated, as follows.

Product

Region

Knife
Dish Towel
Coffee Mug
Fork
Spoon
Tongs
Hot Pad
Dinner Glass
Wine Glass
Spatula
Tea Cup
Juice Glass
Tumbler

Western Region
Eastern Region
Southern Region
Western Region
Western Region
Western Region
Eastern Region
Southern Region
Southern Region
Eastern Region
Southern Region
Southern Region
Southern Region

You want BarTender to print a single item for each region that has all the products from that region printed on the item. The following procedures describe how to create the database connection, enable the printing of multiple records per printed item, and add the records to your .

In this example, when you print your document, the result is three items that resemble the following.

Southern Region

Coffee Mug, Dinner Glass, Wine Glass, Tea Cup, Juice Glass, Tumbler


Eastern Region

Dish Towel, Hot Pad, Spatula


Western Region

Knife, Fork, Spoon, Tongs

Three items are printed because there are three regions in the database and all the products for each region fit on one printed item. The maximum number of products per printed item is set to six, so if a region had exceeded six products, the additional products for that region would have been printed on a separate item. Similarly, if you were to add another region, an additional item would be printed.