Database Data Source

With "Database" data source, the field will draw data from selected database table. You set up the database data source in the following steps.

• First, select "Database" option from the "Data Source" combo box (see 1 in fig).
• Secondly, select a database to work with. You may select a database from database list (See 2 in fig), or you may choose a database from the system (see 3 in fig).
• Thirdly, select a table from the "Table" combo box (see 4 in fig). You may view the contents of the table by clicking at the button beside the Table combo box (see 5 in fig).
• Then, select a Key Database Field from the "Key Field" combo box (see 6 in fig). The data records to be printed will be ordered by this Key Database Field. Note this Key Database Field will be shared among all label fields that uses the same database/table combination.
• If you want the key data comes from user input at print time, then give a prompt text (see 7 in fig). If, instead, you want the key data be determined by an expression, then check the "Use Linked KeyValue" checkbox. (see 11 in fig). Please see Linked Expression Datasource for details of how to set up Linked-Expression.
  For prompted key, user will be prompted for entering value at printed time, whereas for linked expression key value, the final value will be determined by the formula and values of referenced label fields.
• Select an Output Database Field (see 8 in fig). This is the Database Field whose contents will be printed.
• Set the length of this label field in number of characters (see 9 in fig). This can be bigger or smaller than the real length of the Output Database Field.
• Set justification for the Output Database Field (see 10 in fig).