HDR/DTL Print (XF390)
The type for functions to print out a sigle record in the primary table
and related records in detail tables. When executed, it will fetch the
header record and select related
detail records to generate a PDF file to be browsed on PDF Reader.
Sample Function of HDR/DTL Print
Editting the definition of the function above
Elements to be defined
<
Basic Attributes>
Function Type - Fixed value
Function ID - Fixed and unique value in the system
Function Name - Descriptive expression of the function.
HDR Table - The main table which records to be processed. Possible to define alternative
key to be handled.
Page Size - Size of print sheet: A4, A5, A6, B2, B3, B4, B5, B6, LETTER
Page Direction -
NORMAL or
LANDSCAPE
Margins(L;R;T;B) - Margins points from each rim of sheet by left, right, top and bottom.
FYI, the size of A4 is 595*842 points and 1inch equals to 72 points.
With Page No - If checked, page no is printed on the bottom center like -1-.
<
HDR Fields>
Settings of phrases printed on the header area of the sheet. Right-click
on the list to add/delete phrases. Drag the row of phrase to change order.
Select the row to edit attributes as follow.
Block - Type of phrase.
HEADER or
PARAGRAPH.
Alignment - Alignment of the phrase.
LEFT, RIGHT or
CENTER
L/R Margin - Margins from left and right side of the sheet
Spacing After - Margin to the following phrase row. For example, if font size of current
phrase is 12, margin to the next phrase is 18(1.5 times of font size).
Eventually if
Spacing After is -18, following phrase row is
merged with the current phrase row.
Phrase Formula - A set of keywords to describe the phrase. Refer to
Keyword List below for details.
Font - Font for the phrase. These fonts are for printing and they are defined
in the tab of
Others of
System definition.
Size - Size of the font. Value is between 8 and 40.
Style - Style of the font. Values:
Normal, Bold, Italic, BoldItalic, Underlined.
* Available Keyword List *
&Text(text): Fixed string value
&DataSource(name;format): String value of the datasource specified by name. Value is editable by format(cf.Edit Codes).
&DataSourceImage(name;x;y;w;h): Keyword for the datasource which ext. type is IMAGE. Specify bounds of
the frame.
&Line(x1;y1;x2;y2): Line drawn from cordinate(x1,y1) to cordinate(x2,y2)
&Rect(x1;y1;x2;y2): Rectangle drawn from cordinate(x1,y1) to cordinate(x2,y2)
&SystemVariant(id): String value of system variant specified by id
&Date(format): Current date editted by format(cf.Date Format)
&DateTime(format): Current date and time editted by format(cf.Date Format)
&Image(name;x;y;w;h): Content of the image file specified by name with bounds.
&Barcode(name, type): Barcode of the value of datasource specified by name. You can specify
the type of barcode(cf. Barcode type). Default of barcode type is NW7. This is a valid keyword for PARAGRAPH
blocks.
<
Columns - Definition of List Groups>
Settings of list group allocated to the detail table. Right-click on the
list to add/delete phrases. Drag the row of phrase to change order. Select
the row to edit attributes as follow.
Caption - Title of the list
Size of Caption - Size of the font. Value is between 8 and 40.
Style of Caption - Style of the font. Values:
Normal, Bold, Italic, BoldItalic, Underlined.
DTL Table - The table which records to be listed. It has to be
Child or
Refered table of HDR table.
Order By - Order of rows listed. Possible to put fields on the join tables as well
as ones on the HDR table.
Fixed Where - Fixed where criteria integrated into SELECT statement. It has to be
for fields on the primary table. You can use User/Session attributes as
variants.
Font - Font for columns listed. These fonts are for printing and they are defined
in the tab of
Others of
System definition.
Size - Size of the font. Value is between 8 and 40.
Style - Style of the font. Values:
Normal, Bold, Italic, BoldItalic, Underlined.
<
Columns - Definition of Fields>
Definitions of columns to be listed which are fields on the DTL table or
join tables. Right-click on the list to add/delete columns. Drag the row
of column to change order of columns. Select the row to edit attributes
of the definition as follow.
Table - Table ID and name which owns the field (Non editable)
Type - Table type of the table (Non editable)
Field - Field ID and name (Non editable)
Type - Data type, length and ext-type of the field (Non editable)
Caption - Column heading. Select
Column Name or
Value. By using SESSION_ATTRIBUTE:id, you can control column heading dinamically
(Note that you can not check design of the panel on Editor then).
Width Rate - Width of the column in percent to the row width
Alignment - Alignment of column value.
LEFT, RIGHT or
CENTER
Edit Code - Valid for date and numerous fields(cf.
Edit Codes)
Barcode Type - Specify type if you need to print value as barcode.
With Total - Valid for numerous fields. If checked total value is printed at the
bottom of list.
<
Where-Used>
The list of functions using this function. Right-click on the row to jump to the definition.