Data Logging and Display • Columns : Click to launch the Columns dialog , where you can configure the settings (such as label, column, width, etc.) for the columns of the Grid object. • Data : Click to launch the Data dialog , where you can specify a data source for the Grid object. • Advanced : Click to launch the Advanced dialog , where you can configure several settings for the Grid object. Columns dialog You can configure the settings for each column displayed by the Grid object during runtime, as follows: Columns dialog • Column : The ID Number defines the position of the column in the table. • Label :
Enter a Title for each column, which will display as the heading (first) row of the Grid object. Tip: You can configure tags between curly brackts in the Label field to modify it dynamically during runtime. When the label is blank (e.g., ""), then the width of the column is set to 0 during runtime. This option is useful to hide columns during runtime. • Field : Enter the name of the field (column) in the SQL Relational Database to which the Grid object is linked. If this field is left in blank, the text configured in the Label field will be used as the Field name. (This setting is available only when the Data Source type is set to Database.) • Type :
Select the Type of interface that will be used in the column. The options are: Note: Page 264 InduSoft Web Studio Type Description Text Displays alphanumeric values Numeric Displays numeric values Picture Displays the picture (*.bmp or *.ico format) from the data source. For instance, if the value from the data source is MyFile.bmp, the grid object will display the picture from the file MyFile.bmp stored in your project folder. The picture will be automatically resized to fit the cell of the grid object. The picture file(s) must be stored in the Web sub-folder of your project folder to support this feature on the Thin Client stations.
CEView projects support pictures in bitmap format (*.bmp), but not in icon format (*.ico). Checkbox Displays checkbox interfaces. The checkbox will be unchecked if the value read from the file is 0, or "FALSE"; otherwise, the checkbox will be checked. By default, IWS will use the value 0 for unchecked and the value 1 for checked. Time Displays the value in the Time format (e.g., HH:MM:SS). This setting is available only when the Data Source type is set to Database. Date Displays the value in the Date format (e.g., MM/DD/YYYY). This setting is available only when the Data Source type is set to Database. Date/Time Displays the value in the Date/Time format (e.g., MM/DD/YYYY HH:MM:SS).
This setting is available only when the Data Source type is set to Database.