Creating a New Table in the Data Target

  To create a new table in the selected data target:

1. Click Create Table, enter a table name, and click OK.

   The assignment pairs for the table appear under Assigned Fields. Assignment pairs are created when each of the Available Input Fields are used as a template to create new fields. One row in the Assigned Fields list box shows where each selected field will be placed in the new table.

2. Perform one of the following actions:

   • Create a new table by selecting the Create Only export option.

   • Drop and create a new table by selecting the Drop and Create export option.

     Select Drop and Create if there is already a table with the name you entered in Step 1. When you select Drop and Create, SQR Production Reporting Studio attempts to drop the table with the specified name before attempting to create a new one.

3. Review the assigned fields.

   The table is created in the data target based on the query that has been built. To make changes to the assigned fields, you must edit the actual query. To edit the query, click Edit Query or select Report, then Edit Query.

4. Press [F5] or click to process the report.