It is reporting the data in a table by positioning the data to columns and lines without using any tool as excel.
There are two types of table reports:
Table: Reports the data as table.
Pivot Table: Using pivot table reports you can arrange, summarize and analyze the data you enter.
These reports constitute new appearances of work page data in a few seconds.
Generating pivot table report means positioning data components to different places and matching them.
All the data are listed as a table according to the specified filter values.
When a report is taken as pivot table, an empty screen is opened. The user selects the fields from "PivotGrid" list and drag them to the related fields.
Drop Filter Fields Here: The filter lines are dropped here.
Drop Data Fields Here: The numeric data to be summarized or grouped must be dropped to this field.
Drop Row Fields Here: The data to be listed in rows must be dropped to this field.
Drop Column Fields Here: The data to be listed in columns must be dropped to this field.
When you generate a pivot table report, each column of the resource data is used as a field in report. The fields summary great number of data lines taken from resource data.
The field names of the report come from column headings of the resource data. In resource data, each column has a name along the work page's first line.
The other lines under the headings must contain similar elements in same column. For example, the texts, numbers and dates have to be in different columns together. In other words, a text should not be in a column that contains numbers.
Lastly, there should not be an empty column/row in data that are used for pivot table report. For example the rows, which are used to separate the data blocks from each other should be removed.
With Pivot Table totals can be calculated according to selected fields in sum.
Simple Design Reports
The reports of the Logo applications can be taken comprising the desired fields and data by using "Simple Design" option.
The related fields are clicked in reports firstly for the transactions that will be done in report sections. The standard fields and column headings are listed.
In simple design window you can
- Add new fields by using "New" option,
- Change field information by using "Update" option,
- Delete the fields by using "Delete" option.
When you delete a field, in order to arrange the form you can use "Scroll from left to right when the field is delete" option.
In "Size / Orientation" part, the field's measure is specified in unit field. By direction keys, you determine the fields' settlements in report.
Query Assistant Reports
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.