I N D E X    

you must have the rights to write in the directory sql ...

Setting Under state (integration OpenMairie)

To set the state must set
- Parametres title
- Entete Chart
- Data from Table
- Table cell
- Total Table
- Average of the table
- Registration number of the table
- Operations of the table
- Sql (SQL query of the state)

title

- Title: Title text
* Variable: £idx, £aujourdhui ... defined dyn / varetatpdf.inc
* Between [] areas defined in SQL: example [name]
- Height of each line (depending on font size)
- Police (are), attribute, size, borders, alignment of title

- Fond of the title
* With or without (transparent)
* Background color (bottom) => color choices:
- Text color => color choices:
- Intervening early (before the table), end (after painting)

Entete the table

it is the header column that define the areas the SQL query (eg nom_usage as select name from ...)
display name
- With or without entete
- Fond of entete
* With or without (transparent)
* Background color (bottom) => color choices:
- Text color => color choices:
- Height of the header

edge and alignment for each column SQL
- Border for each column: T = top, L = left, B = bottom, R = right
- Alignment of each column: C = center, L = left, R = right, J = justify

Chart Data

it is the data in the table set out in the areas the SQL query

- Width of the table (General settings)
- Edge
* With or without (transparent)

* Choice color of the border:

for a better reading of the data it is possible to switch 2 background colors

- Fond1 color => color choices:
- Fond2 color => color choices:

table cell

it acts cells containing the information specified in the the SQL query

- Bottom of the cell
* With or without (transparent)
- Height of the cell
default font is reduced if the text above and the carriage return is done for areas texts

- Width of each column: the total width of columns must be equal to the width of the table

edge and alignment for each column SQL

- Border for each column: T = top, L = left, B = bottom, R = right
- Bordure1 for each column: T = top, L = left, B = bottom, R = right
- Alignment of each column: C = center, L = left, R = right, J = justify

Total table

These areas are to configure whether to display a total or more

- Bottom of the cell
* With or without (transparent)
* Choice of the background color:
- Size of the total cell
- Height of the cell total

edge and alignment for each column SQL

- Border for each column: T = top, L = left, B = bottom, R = right
- Alignment of each column: C = center, L = left, R = right, J = justify

Average table

These areas are to configure whether to display one or more medium

- Bottom of the cell
* With or without (transparent)
* Choice of the background color:
- Size of the average cell
- Height of the average cell

edge and alignment for each column SQL

- Border for each column: T = top, L = left, B = bottom, R = right
- Alignment of each column: C = center, L = left, R = right, J = justify

registration number of the table

These areas are to configure whether to display one or more registration number of

- Bottom of the cell
* With or without (transparent)
* Choice of the background color:
- Size of the cell number
- Height of the cell number

edge and alignment for each column SQL

- Border for each column: T = top, L = left, B = bottom, R = right
- Alignment of each column: C = center, L = left, R = right, J = justify

Operations of the table


Numerique, total, average number for each column SQL

- Provides a digital display numerique: 999: alphanumeric, 0 (integer), 1 (1 decimal), 2 (2 decimals) ...

These areas are setting if it is hoped an operation (total, average number )

- Total: 0 without column, column 1
- Average: 0 without column, column 1
- Number: 0 without column, column 1

SQL

- SQL query
* Variable: £idx, £aujourdhui ... defined dyn / varetatpdf.inc
* Between [] areas defined in SQL: example [name]