1.7

l
User name: Enter a username that has access to the Oracle server and specified
database. The user only requires Read access to the database.
l
Password: Enter the password that matches the username above.
2.
Click Next and enter the information for the source table.
l
Connection string: Displays the full path to the database.
l
Table: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
l
Encoding: Use the drop-down to select the encoding with which to read the data in
the table.
3.
Click Finish to open the database.
After adding data from a database, the Data Model pane at the right hand bottom shows the
data fields that occur in the data.
The Value column displays data from the first record in the data file. Use the First, Previous,
Next and Last buttons to browse through the records.
Add a counter using the Generate Counter Wizard
Generating a counter is useful for numbered tickets or any other template requiring sequential
numbers but no variable data.
The Generate Counter Wizard creates a record set with a Counter field and in that field, the
current counter value for each record. The Counter starts and stops at set values and is
incremented by a set value as well.
1.
To open the Generate Counter Wizard, select File > Add data > Generate counters.
2. Adjust the settings:
l
Starting value: The starting number for the counter. Defaults to 1.
l
Increment value: The value by which to increment the counter for each record. For
example, an increment value of 3 and starting value of 1 would give the counter
values of 1, 4, 7, 10, [...]
l
Number of records: The total number of counter records to generate. This is not
the end value but rather the total number of actual records to generate.
Page 533