Print Format (Window ID-240)

From iDempiere en

Table of Contents

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.

Print Format - Print Format - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_PrintFormat.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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)


A columnar list report has individual columns (example: list of invoices)

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 clients. Enter a printer name, which applies to ALL clients (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 printengine 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

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/client/org name and connection
@*CurrentDate@ - the print date
@*CurrentDateTime@ - the print time

The layoit 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. supress null does not prevent new line) Print Format - Format Item - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_PrintFormatItem.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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
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}
logic := {|}|{&}
context := any global or window context
value := strings or numbers
logic operators := AND or OR with the previous result from left to right
operand := eq{=}, gt{>}, le{<}, not{~^!}
Examples:

  • @AD_Table_ID@=14 | @Language@!GERGER
  • @PriceLimit@>10 | @PriceList@>@PriceActual@
  • @Name@>J

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

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_PrintFormatItem_Trl.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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

Fields
Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_PrintFormat_Trl.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client 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
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


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.