Print of the reports

Print Previous page Top page Next page

The "Forming reports" mode is intended for creating user reports based on information from the currently active data table.

The following reports can be formed:

- by template (for all data and for the current record);

- for all records in Excel (landscape and portrait orientation). For landscape orientation of the report, the default printer (at least virtual) must be installed.

 

Creation of reports "by template" is carried out by means of Microsoft Office resources (for templates with XLT extension  - MS Excel, with DOT extension - MS Word). Any report is printed on the basis of the template created and customized beforehand in Microsoft Office.

Document template consists of a descriptive part which automatically is not edited and data fields (key fields) which are substituted onto appropriate to them values from the table during report creation. The data fields represent names of table fields as a set of capital letters limited by characters "#". For example, NUMBER is the name of a table field, # NUMBER # is the name of data field in the template.

The reports can be of two sorts:

- The tabular report can be created only on the basis of the template MS Excel and contains data as the table. In the first string of the report template where it is necessary to begin print of the data as the table the names of data fields should be enumerated. As the example the tabular report on the basis of the template with name "ExExcel.xlt" is delivered.

- The report by form represents the document in which the names of data fields are set in any place, selected by the user, and they can repeat. The report by form is created on the basis of the template MS Word. As the example the tabular report on the basis of the template with name "ExWord.xlt" is delivered.

         At creation of the new report it is necessary:

To generate the user template. Templates are formed by Microsoft Office resources (MS Excel, MS Word).  After starting MS Excel or MS Word select the command Create in the File menu. Select the Common bookmark and click twice onto the icon "New document " in MS Word or "Book" in MS Excel.

- To enter the necessary information for creation of the report. To set names of data fields.

To select the command Save as in the File menu ("XLT" template extension for MS Excel, "DOT' extension

for MS Word). In detail the order of creation and support of templates is described in MS Office documentation.