In Logo applications, the entered data is evaluated well-rounded and queries (request to retrieve information from a database) are prepared.
These queries contain all the data that the user need in detail.
These master queries can be made detailed by the user by using query assistant.
When queries are written, LOGO QUERY engine is used that is located in the LOGO Utility.
By means of this engine the following transactions are performed easily in prepared query report:
- Function Usage
- Sorting
- Grouping
- Criteria entry
- Subtotal calculation
The compiled report queries can be send to any applications (Printer, screen, Ms Access, Ms Excel, Table, PDF document, HTML, ASCII) as output.
When compiling queries the users must perform the following transactions:
- The fields are selected that will be take part in the report. (Check/Uncheck transaction – by this transaction the user also connects the tables with each other)
- Necessary functions TOPLA (sum), SAY (count), absolute value (ABS), etc. for certain fields are determined.
- The sorting type for certain fields is determined. (Selection by List / Descending – Increasing)
- The fields that subtotal will be calculated for and fields to be grouped are specified.
- The criteria are determined by using criteria wizard.
You select standard or empty layout for the report. In report definition window;
You reach the standard report unit selection window by "Run" option. Now the designing is finished and the report should be sent to screen or printer or any application as output.
The design is recorded to the system by "Save" option.
The window is closed by "Close" option.