Creating Tables that Use Dynamic Data

By using a table object, you can create a table on your template that contains dynamic data, such as database records or data that is returned from Visual Basic Script. The table object supports this dynamic data by increasing the number of rows or columns automatically at print time to accommodate the data that is merged with the document when it is printed.

ClosedTo add a table object that has dynamic data to the template

  1. On the object toolbar, click the icon to display the table options. Alternatively, click Table on the Create menu.

  2. Click Create Table from Database.

  3. Complete the Database Connection wizard to connect to the database that you want. For more information about the types of databases that you can connect to, refer to Supported Database Types.

  4. Use the Database Setup Dialog to configure additional properties to define the record set that you want from the database, and then click OK to close the dialog.

  5. Click the template at the location where you want to add the table object.

  6. Open the Table Properties dialog to configure the object. To do this, double-click the object. Alternatively, use the secondary mouse button to click the object, and then click Properties.

When you add the dynamic data table to the template by using the Create Table from Database option on the object toolbar, BarTender automatically assigns default table data templates to the table rows. The Table Header template is added to the first row when the connected database includes header fields, and the Data template is added for the row that automatically repeats for each data record when the item is printed.

Advanced users may want configure the dynamic data table manually, in which case the table data templates must also be specified by the user. For more information about how to create a dynamic data table manually, refer to Creating a Dynamic Data Table Manually.

In This Section