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.


To Function Type List