data grid control

Advanced Data Grid Control

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 ).

 

    1. Grid Switches
    2. General Characteristics
    3. Data Format
    4. Row Number Properties
    5. Border Properties
    6. Title Properties
    7. Cell Properties
    8. Column Definitions
    9. 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...