Parameterable states

Previous  Top  Next

Introduction
The editing states permits:

·

To print a list of records defined by the current selection,

·

To do intermediary calculations (counting, amount, average,…) on the selection data.

·

Enhance the presentation of the document with the set to pattern command.

·

Save the definition for future use.

Editing description
The dialogue is cut into two definite parts :
- Superior part: elements of management of the state
- Inferior part: area of definition of the state.

Superior part
'Selecting a field' area.
You can select the fields that will be used for the state. A double-click on the field automatically sends it to the definition area.

'Sorting order' area
Specification of the sorting order for the printing of the state. You can specify several sort criteria.

'Cell' area
Specification of a calculation for the selected column.

'Column' area
Optional attributes of the selected column.

Inferior part

Header :

printed area at the tope of each of the pages of the state.

It corresponds to the name of the different columns. You can modify the title of a column by double clicking on the desired cell.

Body :

To prints area as many times as there are records in the current selection.

You can define, if need be, a display format for the cells of the body state. The display format is defined to a character #. The best example of this is the formatting of the telephone field : if the formatting ##.##.##.##.##. Is inserted in the cell corresponding to the telephone field value 0145214118 and will be presented as follows: 01.45.21.41.18

Footer :

Printed area on the last page of the state…

Note : It is possible to mask the display of these areas by using the hide on the Edition command.

Saving/Opening a state
Note : A same state may be used, no matter what the current selection is as long as it comes from the same user file. However, a state defined from the 'Contact' file can only be used from the 'Operators' file and vice versa.

·	'File' menu 'Save' command

It is important to note that only the characters of state, (definition) are saved and the records that make up the current selection at the point it is saved are not.

·	'File' menu 'Open' command

The definition of the state save and restored beforehand. You can immediately use or even modify at that time.

Creation of a simple list

·	Double-click on the desired field.

The latter is then automatically placed in the preview area.

·	If the case arises, modify the set pattern of your document with the 'Fonts and Styles' menu.

·	Defines the general page layout of the document with the File/Print format command…

·	Defines the header and footer of the page of the document with the File/Header and Footer command.

In this area (repeated on all the pages of the state) you can, for example, display the page numbers or even the date.

Creation of a list with breaks (intermediary calculations)
Defines your state such as what was indicated in the previous paragraph.

Foreword
A break area always has a field whose object it is to sort.
We can only use these breaks without having to select the sorting order fields beforehand.
A state may consist of several break areas, the amount of sorts should as such be at the minimum equivalent to the number of breaks.

Procedure
If you wish to obtain the Contact lists with the records counted by town:

·   Do a sort in the 'Towns' field, by clicking on move, the 'Town' filed into the 'Sorting order' field.
·   Choose the Edition/Insert break command.

A new line is inserted in the definition zone of the state and is titled Break 1.

·	Select on of the cells of the Break 1 line and click on the function number in the cell area.

The note N Number is displayed in the cell selected beforehand.

·	Insert the comment Total # in the [contact]name cell.

The symbol #, (a totally optional use here) forces the display of the town while the sub

totalisation which allows you to have on the same line the town concerned and its total

of corresponding records.