Back to navigation bar   ColGraph

Property
dbColGraph

ColGraph displays the numeric value in a cell as a horizontal bar of different representations.

Fields
This listbox is populated by the numeric fields of the displayed fields. Note that displayed fields is the actual displayed fields less the hidden fields.

Table Name
This read only box is filled with the active table's name during the table selection process in the "Connection" form.

Field Name / Field Number
This the selected field name in the "Numeric Fields" listbox. However, it can be override by the "Field Number" in the case where alias field names are being used.

Width / Height 
This is the actual width of the plot. It can be the count of characters, images or pixels depending on the type of chart. This number together with the Min/Max pair maps the cell value. The default height is 12. There is no default width. If width is blank then the plot will not be effective.

Min / Max
This is the scale of the bar. 

Multiplier
Multiply the value by the scale factor. Percentage can use this to display 15% instead of the actual value of 0.15.

RoundTo
Round to after multiplier. Value = Round(Value * Val(multiply), Val(roundto))

Icon
Name of the gif or jpg file used to produce the chart.

Style
Style (1-8) of bar chart.

  1. Character (e.g. "x") with no value displayed next to it.
  2. Character (e.g. "x") with value displayed next to it.
  3. Icon (e.g. "dollarsign.gif") with no value displayed next to it.
  4. Icon (e.g. "dollarsign.gif") with value displayed next to it.
  5. Icon Stretched (e.g. " bluebar.gif") with no value displayed next to it.
  6. Icon Stretched (e.g. " bluebar.gif") with value displayed next to it.
  7. Icon Shadowed (e.g. "bluebar.gif") with no value displayed next to it.
  8. Icon Shadowed (e.g. "bluebar.gif") with value displayed next to it.


This button builds the dbColGraph property string.


As always, left click to clear above, right click to clear below.