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