Follow-On Topics

Related Topics

# About the Formatting Tab

The Formatting tab provides features for creating a Text document; incorporating the data from a recordset created by a Database Query (ODBC), Database Query (OLEDB), Call Stored Procedure (OLEDB), and Filter Data Step if selected. The main workspace is divided into Header, Detail and Footer areas. Text may be manually entered and columns, properties and variables added from the Task Browser dialog box by dragging and dropping them into the required position in any of the areas. The tab contains the following:
|  | One document — Only one document is generated. This option enables the user to include all the data from the recordset into a single document within the following three areas:
| Click the image to view full size.

|  | Header — Text for the document header may be manually entered and also columns, properties and variables dragged and dropped into the area from the Task Browser dialog box.

|  | Detail — Text for the document detail may be manually entered and also columns, properties and variables dragged and dropped into the area from the Task Browser dialog box.

|  | Footer — Text for the document footer may be manually entered and also columns, properties and variables dragged and dropped into the area from the Task Browser dialog box.

|  | New document when column changes — Multiple documents are generated from the recordset. The records included in each document are determined by the column name selected. For example, column name `companyname` groups all the records where `companyname = "Quadrant Software B.V."` into one document and each subsequent company into a new document. As for the One document option, the user may include data in three area. NOTE: In order for the grouping to work in this manner the column selected must be included as a primary sort key in the Database Query (ODBC), Database Query (OLEDB), or Call Stored Procedure (OLEDB) Step.

|  | New document for each row — This option is used when a new document is required for each row contained in the recordset. For example, where the singular row may comprise of a message appropriate for sending as an SMS text message. A single text box is provided into which text may be manually entered and also columns, properties and variables dragged and dropped into the it from the Task Browser dialog box.

Copyright © 2018 Quadrant Software B.V. All rights reserved.