To open the Database Connection Setup dialog, press Ctrl+D on your keyboard.
Database Connection Setup Dialog |
The Database Connection Setup dialog is used to setup one or more databases to be read from at print time.
|
|
To open the Database Connection Setup dialog, press Ctrl+D on your keyboard. |
Select Database Connection Setup from the File menu.
Select the 
icon on the main toolbar.
Select Print from the File menu to launch the Print dialog. On the Quantity mini-tab, select the Database Connection Setup button.
Double-click on a text or barcode object on your template to open the Properties dialog. On the Data Source property page, set the data source type to Database Field. Click on the Database Connection Setup button.
In the Data Sources pane of the Toolbox, open the context menu for Database Fields. Select Database Connection Setup.
|
|
If you have not previously connected to a database, the following methods will launch the Add Database Connection Wizard. Complete the wizard to display the Database Connection Setup dialog. |
The All Database Tree View (located on the left side of the Database Connection Setup dialog) gives the user access to all available databases, including tables and fields for view, modifications, queries, SQL statements, etc. Any level of the tree view can be expanded by clicking on the (+) sign to the left of its icon and collapsed by pressing the (-) sign.
The root item of the tree view is All Databases. Below it you will find all of the databases that have been added. Beneath each database is a list of all of the tables selected for that database. Below each table are the fields in that table. Selecting a particular item in the tree view will show its corresponding options in the tabs to the right of the tree view. The selected item determines which Database Connection Setup tabs are made available. You can display a context menu with various database options by right-clicking on an item in the All Databases tree.
Add. Displays the Add Database Connection Wizard, which allows you to add a database to the active
Remove. Removes the selected database or table.
On the right side of the Database Connection Setup dialog, the following tabs allow you to customize your database connection. These tabs will appear based on the item that is selected in the All Databases tree.
Tables. Allows the user to view, add, and remove tables from the selected database.
Query. Specifies the criteria which records from the selected database must meet in order to be printed.
Sort. Sorts selected fields from the selected database.
SQL. Allows the user to write custom SQL statements for the selected ODBC or OLE DB data source.
Master Segment. Sets the Master Segment for an SAP IDoc.
Options. Specifies various options for the selected database.
Status. Displays the status of the item selected in the All Databases tree.
Browse. Allows the user to view record data of the item selected in the All Databases tree.
