Print of the reports |
Print of the reports mode is intended for creation of the user's reports on the basis of the information from data table active in the current moment. The given mode is called by choice of Print reports menu item or by pressing of the appropriate button on the main panel. The reports creation is executed by 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. |