A B C D E F G H I J K L M N O P Q R S T U V W XYZ
A range is a set of values between two limits. Whether or not the two limits are included in the range is defined by which to keyword is used. To exclude a limit, add an underscore (_) to the side of the to which youd like to exclude. For example, the formula 2 to 4 returns numbers 2, 3, and 4; 2 _to 4 returns the numbers 3 and 4, while 2 _to_ 4 returns only 3.
Range Operators enables you to create and test range values,
The following "reports" are available:
Author of the report.It can be added to the report as Special Field or it can be used as function in a formula.
Comments to the report.
It can be added to the report as Special Field or it can be used as function in a
formula.
Date on
that the report has been created.
It can be added to the report as Special Field or it can be used as function in a
formula.
File name of the
report.
It can be added to the report as Special Field or it can be used as function in a
formula.
Title of the report.
It can be added to the report as Special Field or it can be used as function in a
formula.
Microsoft's Report Definition Language, an XML-based schema for designing report templates, used by Microsoft's reporting software.
The number of records that has been fetched for this report.
It can be added to the report as Special Field or it can be used as function in a
formula.
The number of the current record.
This number will not be
reseted for each group. It is starting with 1.
It can be added to the report as Special Field or it can be used as function in a
formula.
A record is a single element of a database transaction which contains each field defined for this transaction. This is the logical equivalent to a row of a database table. Each record is displayed in its own detail section in the report, using whichever fields you have selected for each record by dragging them into the detail section.
A record selection formula is a formula which defines which
records to select for the report. It must return a Boolean value, and is
evaluated for each record. If it evaluates as true, the record is selected and
displayed, if it evaluates as false, the record is not selected and not
displayed. By default, this formula is not set, and every record is chosen.
This formula can be set in the
It can be added to the report as Special Field or it can be used as function in a
formula.
The report header is a rectangular area in your report labeled "Report Header". The report header is rendered once in your report, at the very beginning of the report.
The report footer is a rectangular area in your report labeled "Report Footer". The report footer is rendered once in your report, at the very end of the report.
As the name implies, selecting reverse order orders exactly in a reverse way, that is, from highest to lowest, or from Z to A, etc.
Row buffering is intended for rendering large amounts of data. Buffering rows causes the engine to only fetch parts of the data at a time, reducing memory usage, but raising the rendering time. For details see Row Buffer.
RTF stands for Rich Text Format, and is a method of encoding formatting and document structure (such as bold text, paragraphs, and font sizes) on ASCII basis. It is possible to export to RTF format from within the viewer. Simply click on the export as icon, and select RTF as your export format. This will export your report as a RTF file.
See: Text Interpretation.
The ruler is a measuring tool to the top and to the left of your reports desktop. Its units depend on your locale settings from the Options, and it enables you to create your report with extreme accuracy.
In aggregate functions, it is possible to keep track of a running total as you add each record into the computation of the result. This running total can be shown in charts or other functions. For example, for adding up all numbers with SUM [1,2,3,4,5], the running totals after each new record would be [1,3,6,10,15], and the result of the aggregate function would be 15.
i-net software strives to provide accurate product documentation. Please give us your feedback using the form below.
NOTE: This form is for documentation feedback only. For technical assistance, please send an email to crystalclear@inetsoftware.de.