I N D E X
you must have the write access on the directory /sql/..
Under states Settings
- title setting
- head board
- head data
- board Cells
- board sum
- board average
- board number records
- board operations
- sql
Title
- title : text
* variable:�idx,�aujourdhui ... define in dyn/varetatpdf.inc
* fields define in the SQL request between [] : example [nom]
- height of each line
- font, attributes, size, border, title align
- title background
* with or without (transparent)
* back color => color choice : 
- text color => color choice: 
- interval between board (before) , end
Board Head
it is the columns of the board define by the fields of the request
(ex select nom_usage as nom from ...) affichage de nom
- with or whithout columns head
- head back
* with or without (transparent)
* back color (with)=> color choice: 
- text color => color choice: 
- head hight
border and align of the columns SQL
- border of each column: T = top, L= left, B = bottom, R= right
- columns align : C= center, L= left, R =right, J = justify
Board Data
it is the columns of the board define by the fields of the request
(ex select nom_usage as nom from ...) affichage de nom
- board width
- border
* with or without (transparent)
* choice border color: 
for the best data reading, it is possible to alternate 2 back colors
- back color 1 => color choice : 
- back color 2 => color choice: 
Board cells
it is the columns of the board define by the fields of the request
(ex select nom_usage as nom from ...) affichage de nom
- cells back
* with or without (transparent)
- cells height
By default, the font size is reduced if there is a lot of characters and the carriage return
is made in the text zones
- width of each columns: the sum of the width columns will be lower or equal with the board width
columns border and align
- border for each columns: T = top, L= left, B = bottom, R= right
- border 1 for each columns: T = top, L= left, B = bottom, R= right
- aligne for each columns : C= center, L= left, R =right, J = justify
Board total
If you want one or several columns total
- cells back
* with or without (transparent)
* choice back color : 
- font size
- height
border and align
- border: T = top, L= left, B = bottom, R= right
- align : C= center, L= left, R =right, J = justify
board average
If you want one or several columns average
- cells back
* with or without (transparent)
* choice back color : 
- font size
- height
border and align
- border: T = top, L= left, B = bottom, R= right
- align : C= center, L= left, R =right, J = justify
count the records
If you want one or several columns count
- cells back
* with or without (transparent)
* choice back color : 
- font size
- height
border and align
- border: T = top, L= left, B = bottom, R= right
- align : C= center, L= left, R =right, J = justify
Board operation
Numeric, total, average, count for each columns SQL
- numeric for numeric display: 999: alphanumeric, 0 (integer), 1 (1 decimal), 2 ( 2 decimale) ...
the setting is compulsory if it is an operation (total, average, count)
- total : 0 colone sans, 1 colone avec
- average : 0 colone sans, 1 colone avec
- count : 0 colone sans, 1 colone avec
SQL
- SQL : request
* variable: £idx, £aujourdhui ... define in dyn/varetatpdf.inc