Data Grid Parameters
Whichever
method ( file, html code, server process etc.) you choose
to supply the data grid with the configuration options, the
various parameters all follow the same format of
[Parameter Name] , [Parameter Value].
Below you will find each option detailed with examples for
supplying by file and html code.
Please
Note : Parameters Names are case sensitive. ( i.e.. axis
is not the same as Axis ).
- Grid Switches
- General Characteristics
- Data Format
- Row Number Properties
- Border Properties
- Title Properties
- Cell Properties
- Column Definitions
- Multi Language Character Set
GridSwitches
( Boolean flags )
Parameter |
Description |
Example |
titlearea |
Specifies whether a Title area is
to be drawn
Range of Values : true or false |
File Example :
titlearea: true
Html Code Example :
<PARAM name="titlearea" value="true">
|
|
rownumbers
|
Specifies whether rows should be
numbered
Range of Values : true or false |
File Example :
rownumbers:
true
Html Code Example :
<PARAM name="rownumbers"
value="true"> |
|
cellgrid |
Specifies whether cells should be outlined
Range
of Values : true or false |
File Example :
cellgrid:
true
Html Code Example :
<PARAM name="cellgrid"
value="true"> |
|
transcells |
If
a background image is used then you may wish to
make the cells transaparent.
Range
of Values : true or false |
File Example :
transcells:
true
Html Code Example :
<PARAM name="transcells"
value="true"> |
|
displaytotals |
Specifies
whether numeric & currency columns should have
a total displayed
Range
of Values : true or false |
File Example :
displaytotals
:
true
Html Code Example :
<PARAM name="displaytotals"
value="true"> |
|
columnheadings |
Specifies
whether column headings should be drawn
Range
of Values : true or false |
File Example :
columnheadings:
outline
Html Code Example :
<PARAM name="columnheadings"
value="true"> |
|
^back to top
General
Characteristics
Parameter |
Description |
Example |
bgcolor |
Specifies the Background Color
Range of Values : Color Definition
click here for defining
colors. |
File Example :
bgcolor: white
Html Code Example :
<PARAM name="bgcolor" value="#FFFFFF">
|
|
bgimage
|
Specifies a background image for
the cell area
Range of Values : URL to image file |
File Example :
bgimage:
cellbg.gif
Html Code Example :
<PARAM name="bgimage"
value="cellbg.gif"> |
|
scrollbarbgcolor |
Specifies the background color for the scroll bars
Range of Values : Color Definition
click here for defining
colors. |
File Example :
scrollbarbgcolor:
blue
Html Code Example :
<PARAM name="scrollbarbgcolor"
value="#0000FF"> |
|
dateformat |
Specifies
the Date Format for interpreting any dates within
the data
Range
of Values : Date Format
click here for Date
Definitions |
File Example :
transcells:
true
Html Code Example :
<PARAM name="transcells"
value="true"> |
|
^back to top
Data
Format
Parameter |
Description |
Example |
datafiletype |
Specifies the format of the data,
ie. Fixed Width or Character seperated.
Range of Values : 0 - Character Seperated
or 1 - Fixed Width |
File Example :
datafiletype: 0
Html Code Example :
<PARAM name="datafiletype" value="0">
|
|
dataseperator
|
If character seperated then specifies
the character seperator
Range of Values : Any Alpha Numberic Character |
File Example :
dataseperator:
#
Html Code Example :
<PARAM name="dataseperator"
value=","> |
|
fixedwidths |
If fixed width then specifies the width(in characters)
of each column.
Range of Values : Integers seperated by
a | character.
|
File Example :
fixedwidths:
20|10|25|15
Html Code Example :
<PARAM name="fixedwidths"
value="15|30|30"> |
|
^back to top
Row
Properties
Parameter |
Description |
Example |
rownumbgcolor |
Background color of row numbers
Range of Values : Color Definition
click here for defining
colors. |
File Example :
rownumbgcolor: light grey
Html Code Example :
<PARAM name="rownumbgcolor" value="#BBBBBB">
|
|
rownumtxtcolor
|
Text color of row numbers
Range of Values : Color Definition
click here for defining
colors. |
File Example :
rownumtxtcolor:
black
Html Code Example :
<PARAM name="rownumtxtcolor"
value="#000000"> |
|
^back to top
Border
Properties
Parameter |
Description |
Example |
borderwidth |
Specifies the width of the border
Range of Values : Integer Value. If no
border is required set this value to 0. |
File Example :
borderwidth: 1
Html Code Example :
<PARAM name="borderwidth" value="3">
|
|
bordercolor
|
Specifies the base color of the
border.
Range of Values : Color Definition
click here for defining
colors. |
File Example :
bordercolor:
#999999
Html Code Example :
<PARAM name="bordercolor"
value="grey"> |
|
borderstyle |
Specifies whether the border should be Plain,
Raised or Sunken.
Range of Values : 0 - Plain, 1 - Raised,
2 - Sunken
|
File Example :
borderstyle:
1
Html Code Example :
<PARAM name="borderstyle"
value="0"> |
|
^back to top
Title
Properties
Parameter |
Description |
Example |
titletext |
Specifies the Title Text
Range of Values : Text |
File Example :
titletext: Data Grid Title
Html Code Example :
<PARAM name="titletext" value="Data
Grid Title"> |
|
titlefont
|
Specifies the Title Font
Range of Values : Font Definition
click here for defining
fonts |
File Example :
titlefont:
Arial,B,16
Html Code Example :
<PARAM name="titlefont"
value="Arial,BI,14">
|
|
titlecolor |
Specifies the text color
Range of Values : Color Definition
click here for defining
colors. |
File Example :
titlecolor:
blue
Html Code Example :
<PARAM name="titlecolor"
value="#0000FF"> |
|
titlealign |
Specifies
the text alignment
Range
of Values : Left, Right or Center
|
File Example :
textalign:
right
Html Code Example :
<PARAM name="textalign"
value="center"> |
|
titlebgcolor |
Specifies
the title area background color
Range of Values : Color Definition
click here for defining
colors. |
File Example :
titlebgcolor:
white
Html Code Example :
<PARAM name="titlebgcolor"
value="#FFFFFF"> |
|
titleimage |
Specifies
the URL of an Image file
Range
of Values : Image file URL
|
File Example :
titleimage:
title.gif
Html Code Example :
<PARAM name="titleimage"
value="title.gif"> |
|
^back to top
Cell
Properties
Parameter |
Description |
Example |
cellgridline |
Specifies the grid line style
Range of Values : 1- Solid, 2- dotted, 3-
dashed(short), 3- dashed(long) |
File Example :
cellgridline: 1
Html Code Example :
<PARAM name="cellgridline" value="2">
|
|
cellgridcolor
|
Specifies the grid line color
Range of Values : Color Definition
click here for defining
colors. |
File Example :
cellgridcolor:
175,175,175
Html Code Example :
<PARAM name="cellgridcolor"
value="light grey">
|
|
cellfont |
Specifies the cell text font
Range of Values : Font Definition
click here for defining
fonts. |
File Example :
cellfont:
Arial,N,12
Html Code Example :
<PARAM name="cellfont"
value="Arial,N,10"> |
|
celltextcolor |
Specifies
the cell text color
Range of Values : Color Definition
click here for defining
colors.
|
File Example :
celltextcolor:
black
Html Code Example :
<PARAM name="celltextcolor"
value="#000000"> |
|
cellbgcolor |
Specifies
the cell area background color
Range of Values : Color Definition
click here for defining
colors. |
File Example :
cellbgcolor:
white
Html Code Example :
<PARAM name="cellbgcolor"
value="#FFFFFF"> |
|
cell_mo_textcolor |
Specifies
the text color upon Mouseover for cells which
have a URL Link attached
Range of Values : Color Definition
click here for defining
colors.
|
File Example :
cell_mo_textcolor:
white
Html Code Example :
<PARAM name="cell_mo_textcolor"
value="white"> |
|
cell_mo_bgcolor |
Specifies
the cell background color upon Mouseover for cells
which have a URL Link attached
Range of Values : Color Definition
click here for defining
colors.
|
File Example :
cell_mo_bgcolor:
black
Html Code Example :
<PARAM name="cell_mo_bgcolor"
value="black"> |
|
^back to top
Column
Definitions
For
each column in the data grid, 12 characteristics can
be defined,
Column Heading Text
Data Type
Background Color
Text Color
Width (in pixels)
Alignment
Default URL
Default Target Frame
Currency Symbol
Number of decimal places to display
Image
Tool Tip text
These
are supplied via the "columnN" parameter (where
N is an integer ranging from 1 to the total number of
columns). Each item above is separated by a | character.
For the Data Type Item the following are
supported,
- 0 - Text ( default )
- 1 - Numeric
- 2 - Date
- 3 - Currency
Alignment - can be one of "left",
"right" or "center"
Currency Symbol - If the Data Type is set
to currency then all cells in this column will have
this character placed in front. (eg. "$").
Number of decimal places to display - For
Numeric or Currency types the data is held in the
format and precision is which it is supplied, but
using this element you can specify only to display
a certain number of decimal places. e.g. for currency
types you may wish to only display to 2 decimal places.
For
example if we have 4 columns of data,
File
Example :
column1: Product|0|white|black|150|left| | | |0| |Product
Titles
column2: Standard|3|164,164,186|40,40,70|75|right|
| |$ |2| |Standard License Price
column3: Professional|3|164,164,186|40,40,70|100|right|
| |$ |2| |Professional License Price
column4: Launch Date|2|164,164,186|40,40,70|125|center|
| | |0| |Latest Release Launch Date
Html
Code Example :
<param
name="column1" value="Product|0|164,164,186|40,40,70|150|left|
| | |0| |Product Titles">
<param name="column2" value="Standard|3|164,164,186|40,40,70|75|right|
| |$ |2| |Standard License Price">
<param name="column3" value="Professional|3|164,164,186|40,40,70|100|right|
| |$ |2| |Professional License Price">
<param name="column4" value="Launch
Date|2|164,164,186|40,40,70|125|center| | | |0| |Latest
Release Launch Date">
|
^back to top
Multi
Language Character Sets
If your data incorporates characters which are not
included in the Western Alphabet (eg. Japanese or Eastern
European characters) then the data grid provides the
ability for displaying such character sets.
To change the character set you will need to add the
following parameter between the <applet> and </applet>
tags,
<param
name="charset" value="SJIS">
Please Note: The "charset" parameter
will only work where Data is read from a plain text
file or server side process (ie. not HTML Parameters).
For futher information on specifiying character sets
please click here.
|
^back to top
<< Back to Documentation Index
<< Back to Getting
Started
|
Getting Started
Documentation
Examples
Purchase
Data
Grid Control Home
Graph
& Charting
Pie
Chart
Line Graph
Vertical
Bar Graph
Stacked
Bar Graph
Horizontal
Bar Graph
Area
Graph
more...
|