Numeric Column Delimiter | Delimiter to use for numerical data. |
Text Column Delimiter | Delimiter to use for text. |
Separator | Character used to separate data. |
Fixed Length Columns | Indicates whether the columns will be a fixed length. |
One Column per Line | Indicates whether there will be one column per line. |
Data Source | Data source against which you built your query. (You connect to a data source in the Data Connection window.) |
Query | Name of the query used to create the report. |
Display | How the information in the Export Report Layout window displays. Full Name—Displays the schema, table, and field name. For example, Sample.Customers.Cust_Num. Key Name—Displays the table and field name. For example, Customers.Cust_Num. None—If you don’t check either option, just the field name displays. For example, Cust_Num.
|
Data Target | Data target to which you are exporting. When you select a valid data target, the available schema for the target appears under Available Output Fields. |
Create Table | Creates a new table in the selected data target. Click Create Table, enter a table name, and click OK. To change the table, click Change. When you create a new table, the assignment pairs for the table appear under Assigned Fields. Assignment pairs are created when each of the Available Input Fields is 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. |
Export Options | How to export the data to the data target when you create a new table. (If you are individually assigning fields to a table that already exists, the export options are disabled.) Create Only—Creates a new table in the data target. Drop and Create—Looks to see if there is table with the same name that you entered in the Create Table field. If such a table exists, SQR Production Reporting Studio attempts to drop the table with the duplicate name before attempting to create a new table in the data target.
|
Available Input Fields | Fields available to export. The available input fields are the fields you selected in your query. |
Available Output Fields | For new tables in the data target, the Available Output Fields are the fields that will be in the new table. The output fields are created based on the data types of the fields in the query. If you are individually assigning fields to a table that already exists, the Available Output Fields are the schemas, tables, and fields that are already in the data target. Note: If you are individually assigning fields to a table that already exists, Assign and Assign All are enabled when you select the appropriate fields. Click Assign to add the selected Input Field and Output Field to the Assigned Fields. To assign more then one Input Field and Output Field, select the desired Input Field, select a table under Available Output Fields, and click Assign All. When you click Assign All, SQR Production Reporting Studio starts with the selected Input Field and attempts to assign the Input Fields one-by-one to the fields in the table selected under Available Output Fields. |
Assigned Fields | Assignment pairs for the table. The Assigned Fields show you exactly which Input Fields (from the data source) will be inserted into which output fields (in the data target). Note: If you are individually assigning fields to a table that already exists, Remove and Remove All are enabled. Click Remove to remove the selected assignment pair. Click Remove All to remove all the assignment pairs. |