Print Format (Window ID-240)
From iDempiere en
Window: Print Format
Description: Maintain Print Format
Help: The print format determines how data is rendered for print.
Tab: Print Format
Description: Maintain Print Format
Help: The print format determines how data is rendered for print.
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | AD_PrintFormat.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | AD_PrintFormat.AD_Org_ID numeric(10) Table Direct |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | AD_PrintFormat.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | AD_PrintFormat.Description character varying(255) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
AD_PrintFormat.IsActive character(1) Yes-No |
| Default | Default value | The Default Checkbox indicates if this record will be used as a default value. | AD_PrintFormat.IsDefault character(1) Yes-No |
| Table | Database Table information | The Database Table provides the information of the table definition | AD_PrintFormat.AD_Table_ID numeric(10) Table Direct |
| Report View | View used to generate this report | The Report View indicates the view used to generate this report. | AD_PrintFormat.AD_ReportView_ID numeric(10) Table Direct |
| Form | If Selected, a Form is printed, if not selected a columnar List report | A form has individual elements with layout information (example: invoice, check)
|
AD_PrintFormat.IsForm character(1) Yes-No |
| Table Based | Table based List Reporting | Table based columnar list reporting is invoked from the Window Report button | AD_PrintFormat.IsTableBased character(1) Yes-No |
| Print Paper | Printer paper definition | Printer Paper Size, Orientation and Margins | AD_PrintFormat.AD_PrintPaper_ID numeric(10) Table Direct |
| Standard Header/Footer | The standard Header and Footer is used | If the standard header is not used, it must be explicitly defined. | AD_PrintFormat.IsStandardHeaderFooter character(1) Yes-No |
| Print Header/Footer | AD_PrintFormat.AD_PrintHeaderFooter_ID numeric(10) Table Direct | ||
| Print Table Format | Table Format in Reports | Print Table Format determines Fonts, Colors of the printed Table | AD_PrintFormat.AD_PrintTableFormat_ID numeric(10) Table Direct |
| Printer Name | Name of the Printer | Internal (Operating System) Name of the Printer; Please mote that the printer name may be different on different tenants. Enter a printer name, which applies to ALL tenants (e.g. printer on a server).
If none is entered, the default printer is used. You specify your default printer when you log in. You can also change the default printer in Preferences. |
AD_PrintFormat.PrinterName character varying(40) String |
| Header Margin | Margin of the Header in 1/72 of an inch | Distance from the top of the printable page to the start of the main content in 1/72 of an inch (point) | AD_PrintFormat.HeaderMargin numeric(10) Integer |
| Footer Margin | Margin of the Footer in 1/72 of an inch | Distance from the bottom of the main content to the end of the printable page in 1/72 of an inch (point) | AD_PrintFormat.FooterMargin numeric(10) Integer |
| Print Font | Maintain Print Font | Font used for printing | AD_PrintFormat.AD_PrintFont_ID numeric(10) Table Direct |
| Print Color | Color used for printing and display | Colors used for printing and display | AD_PrintFormat.AD_PrintColor_ID numeric(10) Table Direct |
| Jasper Process | The Jasper Process used by the print engine if any process defined | AD_PrintFormat.JasperProcess_ID numeric(10) Table | |
| Window | Data entry or display window | The Window field identifies a unique Window in the system. | AD_PrintFormat.AD_Window_ID numeric(10) Table Direct |
| Copy/Create | Copy existing OR create Print Format from Table | Select either a table to create a print format [creates initial rough layout]
OR a print format to copy into the current print format [copies layout]. |
AD_PrintFormat.CreateCopy character(1) Button |
| Page break per record | Page Break after each record | AD_PrintFormat.IsBreakPagePerRecord character(1) Yes-No | |
| File Name Pattern | AD_PrintFormat.FileNamePattern character varying(255) String |
Tab: Format Item
Description: Print Format Item
Help: Item in the print format maintaining layout information. The following additional variables are available when printing:
@*Page@ - the current page number
@*PageCount@ - the total number of pages
@*MultiPageInfo@ - "Page x of y" - only printed if more than one page
@*CopyInfo@ - if it is a copy of the document "Duplicate" is printed
@*ReportName@ - name of the report
@*Header@ - Full Header with user/tenant/org name and connection
@*CurrentDate@ - the print date
@*CurrentDateTime@ - the print time
The layout logic for forms is:
- if not printed: ignore
- set New Line Position
- new page
- new line, if something was printed since last new line
- format item
- print it (if not null/empty selected)
(i.e. suppress null does not prevent new line)
.png)
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | AD_PrintFormatItem.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | AD_PrintFormatItem.AD_Org_ID numeric(10) Table Direct |
| Print Format | Data Print Format | The print format determines how data is rendered for print. | AD_PrintFormatItem.AD_PrintFormat_ID numeric(10) Table Direct |
| Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | AD_PrintFormatItem.SeqNo numeric(10) Integer |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | AD_PrintFormatItem.Name character varying(60) String |
| Print Text | The label text to be printed on a document or correspondence. | The Label to be printed indicates the name that will be printed on a document or correspondence. The max length is 2000 characters. | AD_PrintFormatItem.PrintName character varying(2000) String |
| Print Label Suffix | The label text to be printed on a document or correspondence after the field | The Label to be printed indicates the name that will be printed on a document or correspondence after the field. The max length is 60 characters. | AD_PrintFormatItem.PrintNameSuffix character varying(60) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
AD_PrintFormatItem.IsActive character(1) Yes-No |
| Centrally maintained | Information maintained in System Element table | The Centrally Maintained checkbox indicates if the Name, Description and Help maintained in 'System Element' table or 'Window' table. | AD_PrintFormatItem.IsCentrallyMaintained character(1) Yes-No |
| Suppress Null | Suppress columns or elements with NULL value | If a Form entry is NULL and if selected, the field (including label) is not printed. If all elements in a table column are NULL and if selected, the column is not printed. |
AD_PrintFormatItem.IsSuppressNull character(1) Yes-No |
| Suppress Repeats | Suppress repeated elements in column. | Determines whether repeated elements in a column are repeated in a printed table. | AD_PrintFormatItem.IsSuppressRepeats character(1) Yes-No |
| Format Type | Print Format Type | The print format type determines what will be printed. | AD_PrintFormatItem.PrintFormatType character(1) List |
| Column | Column in the table | Link to the database column of the table | AD_PrintFormatItem.AD_Column_ID numeric(10) Table Direct |
| Line Width | Width of the lines | AD_PrintFormatItem.LineWidth numeric(10) Integer | |
| Format Pattern | The pattern used to format a number or date. | A string complying with either Java SimpleDateFormat or DecimalFormat pattern syntax used to override the default presentation format of a date or number type field. | AD_PrintFormatItem.FormatPattern character varying(60) String |
| Print Attributes | Print each attributes as report column instead of printing the description of attribute set instance | This control the printing of product attribute set instance. When checked, the report will have one column for each attribute instead of printing the description of attribute set instance. | AD_PrintFormatItem.IsPrintInstanceAttributes character(1) Yes-No |
| Included Print Format | Print format that is included here. | Included Print formats allow to e.g. Lines to Header records. The Column provides the parent link. | AD_PrintFormatItem.AD_PrintFormatChild_ID numeric(10) Table |
| Image Field | The image is retrieved from the data column | The Image URL is retrieved from the data column | AD_PrintFormatItem.IsImageField character(1) Yes-No |
| Image attached | The image to be printed is attached to the record | The image to be printed is stored in the database as attachment to this record. The image can be a gif, jpeg or png. | AD_PrintFormatItem.ImageIsAttached character(1) Yes-No |
| Image URL | URL of image | URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png. | AD_PrintFormatItem.ImageURL character varying(120) URL |
| Area | Print Area | Print area of this item | AD_PrintFormatItem.PrintAreaType character(1) List |
| Barcode Type | Type of barcode | AD_PrintFormatItem.BarcodeType character(3) List | |
| Print Barcode Text | Print barcode text at the bottom of barcode | AD_PrintFormatItem.IsPrintBarcodeText character(1) Yes-No | |
| Relative Position | The item is relative positioned (not absolute) | The relative positioning of the item is determined by X-Z space and next line | AD_PrintFormatItem.IsRelativePosition character(1) Yes-No |
| Set NL Position | Set New Line Position | When enabled, the current x (horizontal) Position before printing the item is saved. The next New Line will use the saved x (horizontal) Position, enabling to print data in columns.
The setting is not restricted to an area (header, content, footer), allowing to align information also with Header and Footer with the Content. |
AD_PrintFormatItem.IsSetNLPosition character(1) Yes-No |
| X Position | Absolute X (horizontal) position in 1/72 of an inch | Absolute X (horizontal) position in 1/72 of an inch | AD_PrintFormatItem.XPosition numeric(10) Integer |
| Y Position | Absolute Y (vertical) position in 1/72 of an inch | Absolute Y (vertical) position in 1/72 of an inch | AD_PrintFormatItem.YPosition numeric(10) Integer |
| Next Line | Print item on next line | If not selected, the item is printed on the same line | AD_PrintFormatItem.IsNextLine character(1) Yes-No |
| Next Page | The column is printed on the next page | Before printing this column, there will be a page break. | AD_PrintFormatItem.IsNextPage character(1) Yes-No |
| Below Column | Print this column below the column index entered | This column is printed in a second line below the content of the first line identified. Please be aware, that this is depends on the actual sequence. Enter a 1 to add the info below the first column. | AD_PrintFormatItem.BelowColumn numeric(10) Integer |
| Line Alignment | Line Alignment | For relative positioning, the line alignment | AD_PrintFormatItem.LineAlignmentType character(1) List |
| Field Alignment | Field Text Alignment | Alignment of field text. The default is determined by the data/display type: Numbers are right aligned, other data is left aligned | AD_PrintFormatItem.FieldAlignmentType character(1) List |
| X Space | Relative X (horizontal) space in 1/72 of an inch | Relative X (horizontal) space in 1/72 of an inch in relation to the end of the previous item. | AD_PrintFormatItem.XSpace numeric(10) Integer |
| Y Space | Relative Y (vertical) space in 1/72 of an inch | Relative Y (vertical) space in 1/72 of an inch in relation to the end of the previous item. | AD_PrintFormatItem.YSpace numeric(10) Integer |
| Max Width | Maximum Width in 1/72 if an inch - 0 = no restriction | Maximum width of the element in 1/72 of an inch (point). If zero (0), there is no width restriction. | AD_PrintFormatItem.MaxWidth numeric(10) Integer |
| Fixed Width | Column has a fixed width | The Column has a fixed width, independent from the content | AD_PrintFormatItem.IsFixedWidth character(1) Yes-No |
| Shape Type | Type of the shape to be painted | AD_PrintFormatItem.ShapeType character(1) List | |
| Max Height | Maximum Height in 1/72 if an inch - 0 = no restriction | Maximum height of the element in 1/72 of an inch (point). If zero (0), there is no height restriction. | AD_PrintFormatItem.MaxHeight numeric(10) Integer |
| One Line Only | If selected, only one line is printed | If the column has a width restriction, the text is broken into multiple lines. If One Line is selected, only the first line is printed. | AD_PrintFormatItem.IsHeightOneLine character(1) Yes-No |
| Fill Shape | Fill the shape with the color selected | AD_PrintFormatItem.IsFilledRectangle character(1) Yes-No | |
| Print Color | Color used for printing and display | Colors used for printing and display | AD_PrintFormatItem.AD_PrintColor_ID numeric(10) Table Direct |
| Print Font | Maintain Print Font | Font used for printing | AD_PrintFormatItem.AD_PrintFont_ID numeric(10) Table Direct |
| Field Style | Field CSS Style | AD_PrintFormatItem.AD_FieldStyle_ID numeric(10) Table | |
| Display Logic | If the Field is displayed, the result determines if the field is actually displayed | format := {expression} [{logic} {expression}] expression := @{context}@{operand}{value} or @{context}@{operand}{value}
Strings may be in single quotes (optional) |
AD_PrintFormatItem.DisplayLogic character varying(2000) Text |
| Arc Diameter | Arc Diameter for rounded Rectangles | Width of the horizontal/vertical diameter of the arc at the four corners | AD_PrintFormatItem.ArcDiameter numeric(10) Integer |
| Order by | Include in sort order | The records are ordered by the value of this column. If a column is used for grouping, it needs to be included in the sort order as well. | AD_PrintFormatItem.IsOrderBy character(1) Yes-No |
| Record Sort No | Determines in what order the records are displayed | The Record Sort No indicates the ascending sort sequence of the records. If the number is negative, the records are sorted descending.
Example: A tab with C_DocType_ID (1), DocumentNo (-2) will be sorted ascending by document type and descending by document number (SQL: ORDER BY C_DocType, DocumentNo DESC) |
AD_PrintFormatItem.SortNo numeric(10) Integer |
| Descending | Sort your data using a SQL Desc Order By statement | AD_PrintFormatItem.IsDesc character(1) Yes-No | |
| Group by | After a group change, totals, etc. are printed | Grouping allows to print sub-totals. If a group changes, the totals are printed. Group by columns need to be included in the sort order. | AD_PrintFormatItem.IsGroupBy character(1) Yes-No |
| Page break | Start with new page | Before printing this item, create a new page | AD_PrintFormatItem.IsPageBreak character(1) Yes-No |
| Calculate Sum (Σ) | Calculate the Sum of numeric content or length | Calculate the Sum (Σ) of the data if the field is numeric, otherwise total sum length of the field. | AD_PrintFormatItem.IsSummarized character(1) Yes-No |
| Running Total | Create a running total (sum) | A running total creates a sum at the end of a page and on the top of the next page for all columns, which have a Sum function. You should define running total only once per format. | AD_PrintFormatItem.IsRunningTotal character(1) Yes-No |
| Calculate Count (№) | Count number of not empty elements | Calculate the total number (№) of not empty (NULL) elements (maximum is the number of lines). | AD_PrintFormatItem.IsCounted character(1) Yes-No |
| Running Total Lines | Create Running Total Lines (page break) every x lines | When you want to print running totals, enter the number of lines per page after you want to create a running total line and page break. You should define running total only once per format. | AD_PrintFormatItem.RunningTotalLines numeric(10) Integer |
| Calculate Minimum (↓) | Calculate the minimum amount | Calculate the Minimum (↓) of the data if the field is numeric, otherwise minimum length of the field. | AD_PrintFormatItem.IsMinCalc character(1) Yes-No |
| Calculate Maximum (↑) | Calculate the maximum amount | Calculate the Maximum (↑) of the data if the field is numeric, otherwise maximum length of the field. | AD_PrintFormatItem.IsMaxCalc character(1) Yes-No |
| Calculate Mean (μ) | Calculate Average of numeric content or length | Calculate the Mean (μ) of the data if the field is numeric, otherwise calculate the average length of the field. | AD_PrintFormatItem.IsAveraged character(1) Yes-No |
| Calculate Variance (σ²) | Calculate Variance | The Variance (σ²) is the a measure of dispersion - used in combination with the Mean (μ) | AD_PrintFormatItem.IsVarianceCalc character(1) Yes-No |
| Calculate Deviation (σ) | Calculate Standard Deviation | The Standard Deviation (σ) is the a measure of dispersion - used in combination with the Mean (μ) | AD_PrintFormatItem.IsDeviationCalc character(1) Yes-No |
| Script | Dynamic Java Language Script to calculate result | Use Java language constructs to define the result of the calculation | AD_PrintFormatItem.Script character varying(2000) Text |
Tab: Item Translation
Description: Print Format Translation
Help:
File:Print Format - Item Translation - Window (iDempiere 1.0.0).png
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | AD_PrintFormatItem_Trl.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | AD_PrintFormatItem_Trl.AD_Org_ID numeric(10) Table Direct |
| Print Format Item | Item/Column in the Print format | Item/Column in the print format maintaining layout information | AD_PrintFormatItem_Trl.AD_PrintFormatItem_ID numeric(10) Table Direct |
| Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_PrintFormatItem_Trl.AD_Language character varying(6) Table |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
AD_PrintFormatItem_Trl.IsActive character(1) Yes-No |
| Translated | This column is translated | The Translated checkbox indicates if this column is translated. | AD_PrintFormatItem_Trl.IsTranslated character(1) Yes-No |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | AD_PrintFormatItem_Trl.Name character varying(60) String |
| Print Text | The label text to be printed on a document or correspondence. | The Label to be printed indicates the name that will be printed on a document or correspondence. The max length is 2000 characters. | AD_PrintFormatItem_Trl.PrintName character varying(2000) String |
| Print Label Suffix | The label text to be printed on a document or correspondence after the field | The Label to be printed indicates the name that will be printed on a document or correspondence after the field. The max length is 60 characters. | AD_PrintFormatItem_Trl.PrintNameSuffix character varying(60) String |
Tab: Translate
Description:
Help:
File:Print Format - Translate - Window (iDempiere 1.0.0).png
| Name | Description | Help | Technical Data |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | AD_PrintFormat_Trl.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | AD_PrintFormat_Trl.AD_Org_ID numeric(10) Table Direct |
| Print Format | Data Print Format | The print format determines how data is rendered for print. | AD_PrintFormat_Trl.AD_PrintFormat_ID numeric(10) Table Direct |
| Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_PrintFormat_Trl.AD_Language character varying(6) Table |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | AD_PrintFormat_Trl.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | AD_PrintFormat_Trl.Description character varying(255) String |
| File Name Pattern | AD_PrintFormat_Trl.FileNamePattern character varying(255) String | ||
| Translated | This column is translated | The Translated checkbox indicates if this column is translated. | AD_PrintFormat_Trl.IsTranslated character(1) Yes-No |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
AD_PrintFormat_Trl.IsActive character(1) Yes-No |
.png){kind=link}
.png){kind=link}