4.4.4 Changing the Column Type in an Embedded Table

By default, all manually created columns in an embedded table are of type 'String'. To change the type of an embedded table column, follow these steps:

1. Right-click the column header, and select 'Column Type' from the context menu. This opens the 'Column Type' dialog box.

2. Select the desired data type from the 'Type' menu. If you select a numeric or date type, a secondary 'Parse Format' menu appears below.

This allows the Embedded Table to convert the data to a standard representa­tion.

3. (Optional) In the 'Parse Format' menu, select the format in which you have entered your data. For example, if you have entered dates in the form “1/13/1995,” select or type “MM/d/yyyy” as the parse format.

4. Click 'OK' to close the 'Column Type' dialog box.

After you have specified a data type for a column of an Embedded Table, any additional data you enter into the column must match this specified type.

Example: Changing the Column Type  >>

In the following example, you will change the data type of an embedded table column from 'String' to 'Integer':

1. Create a new Worksheet.

2. Create a new embedded table with four rows and four columns. See Creating an Embedded Table for instructions on how to create an embedded table.

3. Right-click a header cell and select 'Column Type' from the context menu. This opens the 'Column Type' dialog box.

 

4. Select 'Integer' from the 'Type' menu and click 'OK'.

 

 

See Also

Date and Time Formats, in Report Design, for more information on formats.

Format Tab, in Dashboard Design, for more information on Viewsheet formatting.

<< 4.4.3 Showing and Hiding a Column © 1996-2013 InetSoft Technology Corporation (v11.5) 4.4.5 Editing an Expression Column >>