Example 1
Example 2
Example 3
<REPORT>...</REPORT> Begin A Report, Includes all
statements between the <report> </report> tags. Macro Statements <ASSIGN> <STORE> <RANDOM> <IF> that are within the <Report>...</Report> tags are re-processed for each record permitting sums, averages and other values to be calculated and used in the report.
Reports can be nested to any level at any point within the report
Property |
Description |
ID=name |
Tag identifier |
Style="..." |
Style |
Class=class-name |
Class Name |
SQL=statement |
SQL statement of Report Records |
Table=id |
Reference to a <ReportTable
ID=name> ID for
the Report Records |
Detail=macro-id |
Set the Active Detail based on ID as
each record is processed. The macro-ref should resolve to a valid
<DETAIL id=name> value |
Width=size |
Report Width, if width and height
specified the report is clipped to this area |
Height=size |
Report Minimum Height |
Fit=true | false |
Fit report in a single PDF Page, if
true page width and length is increased to contain the full report, Default
= false perform page
breaks |
clipCell=true | false |
Clip Cell, CellHeight and CellWidth qualifiers
are required |
CellHeight=n |
Cell Height, default=calculated |
CellWidth=n |
Cell Width |
Columns=n |
Number of Columns in report, Default=1 |
ColumnOrder=true | false |
Output Report in Column Order, default=false (row order) see:
report layout |
RowsPerColumn=n | * |
Output Records in even length columns, * = calculate see:
report layout |
cellspacing=n |
space between cells (default=2) |
Border=n |
Size of Border |
BorderColorDark=color |
Dark Border Color (left,top), Default= #ACA899 |
BorderColorLight=color |
Light Border Color (right,bottom), Default = #ECE9D8 |
<REPORTGROUP>...</REPORTGROUP> Create A Report Group,
any number of reporting group can be created
Each group requires a KEY macro reference to determine when a group change occurs
Property |
Description |
ID=NAME |
Report Group identifier |
Style="..." |
Style |
Class=class-name |
Class Name |
PageBreakAfter=true | false |
Page Break After Creating Group,
Default=false |
PageBreakBefore=True | False |
Page Break Before Creating Group,
Default=false |
KeepTogether=True | False |
If true force a page break if
required to keep group detailed on the same
page, Default = false |
SkipIfBlank=True | False |
Skip Group Header / Footer if no detailed were generated,
Default = false |
Key=macro-ref |
Values to determine when the group
changes as the records are read. A Macro of {F1},{F2},...{Fn}
references the fields in the record by number. A Macro reference by
field name is also permitted {State_Name} |
<DETAIL>... </DETAIL> Report, Create a report detail
Property |
Description |
ID=NAME |
Report Detail identifier |
Style="..." |
Style |
Class=class-name |
Class Name |
Cellspacing=n |
cell spacing default=1 |
Cellpadding=n |
cell padding default=2 |
Border=n |
Border Line Width, Default=0 |
Header="fontcolor,
bgcolor" |
Define Color of Column Header font
and background Colors
Default="Black,White" |
<COLUMN>...</COLUMN> Report, Define Detail Columns
Property |
Description |
WIDTH=N |
Column Width (REQUIRED) |
Align=just |
Left, Center, Right |
Valign=just |
Top, Middle, Bottom |
<HEADER>... </HEADER> Report, <REPORT>, <REPORTGROUP> or
<DETAIL> headers
Property |
Description |
Align=just |
Left, Center, Right |
Valign=just |
Top, Middle, Bottom |
ColSpan=n |
<DETAIL> Column to Span Default=1 |
<REPORTTABLE>...</REPORTTABLE> Reporting Table of
Text Comma Seperated Values (CSV) Records
Property |
Description |
ID=id |
Table Identifier |
Delimiter=comma |
Field Delimiter Default = comma |
FirstRowNames = true | false |
Does first row of records contain field names, default = false |
Src="file-spec" |
Report Table is a CSV File. If not
specified the records are in-line |
Fields="spec-list"
|
A List of Field Names
and Formats contained in the table
NAME:text;
LENGTH:n;
FORMAT: char | Integer | Float; |