To meet your needs, we constantly work to improve Querix products.
This means that Lycia documentation is developing as well.
In case you have found a certain dissonance between the provided information and the actual behavior of Lycia 3 and/or your applications, please, let us know about this via documentation@querix.com so that we can introduce the necessary changes to our documentation.
Thank you for your attention and cooperation.
Report writer can arrange the data in accordance with the instructions in the REPORT program block or in the report driver and to perform the output. The output can be sent:
to the screen
to a file
to a printer
to a pipe
To be able to write a report a program must have two components:
REPORT program block that formats the report output
The report driver that invokes and processes the report
The report driver contains the statements that retrieve rows from a database, store their values in program variables and send them to the report. The information is sent to the report in portions called the input records, after the last such record has been received and formatted by the REPORT program block, the aggregate values based on these records are calculated, if required. After that, the report is sent to the output device.
The fact that the processed of data retrieval and data formatting are separated makes it easier to apply the same report to different sets of data.