Before creating new reports or modifying existing SXSi reports, have you:
![]() | made use of the possibilities described in the Views Section? The Views Section generates its own online reports, and does not require preformatting or templates. |
![]() | exported the results of the visible lists in Synexsys? A right-click with the mouse will allow you to export the content of virtually any list. In particular, those including the results of your queries. The queries results grid can be customised based on your needs. You may choose to display or hide column, sort the data based on the column of your choice, and define the way in which columns are displayed. All these format parameters are maintained in HTML outputs. This way you may create professional reports without need of setting any parameters previously. |
Synexsys Inventory is equipped with an independent reporting module. This tool allows creating professional quality reports easily. The list of available reports is stored in the database (or on your drive).
You also have the possibility of creating new reports, modifying existing reports, and deleting SXSi reports.
A report is made of three different files:
![]() | Configuration - This file contains the basic parameters of the report, the SQL query, as well as the selection criteria that will be proposed to you when running the report. |
![]() | Template - This file contains the page layout of the report. |
![]() | Result - This file contains the results of the report. |
To ease the creation of reports, the Configuration and Template files can be edited in MS-Excel.