Printformaat (Venster ID-240)
Uit iDempiere nl
Venster: Printformaat
Beschrijving: Beheer printformaat
Help: The print format determines how data is rendered for print.
TAB: Print Format
Beschrijving: Maintain Print Format
Help The print format determines how data is rendered for print.
Bestand:Printformaat - Print Format - Venster (iDempiere 1.0.0).png
| Naam | Naam | Beschrijving | Help | Specificaties |
|---|---|---|---|---|
| Print Format | Print Format | Data Print Format | The print format determines how data is rendered for print. | AD_PrintFormat_ID numeric(10) NOT NULL ID |
| Client | 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_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 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_Org_ID numeric(10) NOT NULL Table Direct |
| Name | 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. | Name character varying(60) NOT NULL String |
| Description | Beschrijving | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
| Active | Actief | 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. |
IsActive character(1) NOT NULL Yes-No |
| Default | Standaard | Default value | The Default Checkbox indicates if this record will be used as a default value. | IsDefault character(1) NOT NULL Yes-No |
| Table | Tabel | Database Table information | The Database Table provides the information of the table definition | AD_Table_ID numeric(10) NOT NULL Table Direct |
| Report View | Report View | View used to generate this report | The Report View indicates the view used to generate this report. | AD_ReportView_ID numeric(10) Table Direct |
| Form | 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)
|
IsForm character(1) NOT NULL Yes-No |
| Table Based | Table Based | Table based List Reporting | Table based columnar list reporting is invoked from the Window Report button | IsTableBased character(1) NOT NULL Yes-No |
| Print Paper | Print Papier | Printer paper definition | Printer Paper Size, Orientation and Margins | AD_PrintPaper_ID numeric(10) NOT NULL Table Direct |
| Standard Header/Footer | Standard Header/Footer | The standard Header and Footer is used | If the standard header is not used, it must be explicitly defined. | IsStandardHeaderFooter character(1) NOT NULL Yes-No |
| Print Table Format | Print Table Format | Table Format in Reports | Print Table Format determines Fonts, Colors of the printed Table | AD_PrintTableFormat_ID numeric(10) Table Direct |
| Printer Name | 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. |
PrinterName character varying(40) String |
| Header Margin | 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) | HeaderMargin numeric(10) NOT NULL Integer |
| Footer Margin | 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) | FooterMargin numeric(10) NOT NULL Integer |
| Print Font | Print Lettertype | Maintain Print Font | Font used for printing | AD_PrintFont_ID numeric(10) NOT NULL Table Direct |
| Print Color | Print Kleur | Color used for printing and display | Colors used for printing and display | AD_PrintColor_ID numeric(10) NOT NULL Table Direct |
| Jasper Process | Jasper Process | The Jasper Process used by the printengine if any process defined | null | JasperProcess_ID numeric(10) Table |
| Copy/Create | 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]. |
CreateCopy character(1) Button |
| Classname | Classname | Java Classname | The Classname identifies the Java classname used by this report or process. | Classname character varying(240) String |
| Args | Args | null | null | Args character varying(510) String |
TAB: Display Order
Beschrijving: Display Order of the Print Format Items
Help null
Bestand:Printformaat - Display Order - Venster (iDempiere 1.0.0).png
| Naam | Naam | Beschrijving | Help | Specificaties |
|---|
TAB: Sort Order
Beschrijving: Sort Order of the Print Format Items
Help null
Bestand:Printformaat - Sort Order - Venster (iDempiere 1.0.0).png
| Naam | Naam | Beschrijving | Help | Specificaties |
|---|
TAB: Format Item
Beschrijving: 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)
Bestand:Printformaat - Format Item - Venster (iDempiere 1.0.0).png
| Naam | Naam | Beschrijving | Help | Specificaties |
|---|---|---|---|---|
| Client | 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_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 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_Org_ID numeric(10) NOT NULL Table Direct |
| Print Format | Print Format | Data Print Format | The print format determines how data is rendered for print. | AD_PrintFormat_ID numeric(10) NOT NULL Table Direct |
| Sequence | Sequence | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | SeqNo numeric(10) NOT NULL Integer |
| Name | 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. | Name character varying(60) NOT NULL String |
| Print Text | 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. | PrintName character varying(2000) String |
| Print Label Suffix | 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. | PrintNameSuffix character varying(60) String |
| Active | Actief | 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. |
IsActive character(1) NOT NULL Yes-No |
| Centrally maintained | 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. | IsCentrallyMaintained character(1) NOT NULL Yes-No |
| Suppress Null | 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. |
IsSuppressNull character(1) NOT NULL Yes-No |
| Suppress Repeats | Suppress Repeats | Suppress repeated elements in column. | Determines whether repeated elements in a column are repeated in a printed table. | IsSuppressRepeats character(1) NOT NULL Yes-No |
| Format Type | Format Type | Print Format Type | The print format type determines what will be printed. | PrintFormatType character(1) NOT NULL List |
| Column | Column | Column in the table | Link to the database column of the table | AD_Column_ID numeric(10) Table Direct |
| Line Width | Line Width | Width of the lines | null | LineWidth numeric(10) Integer |
| Format Pattern | 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. | FormatPattern character varying(22) String |
| Included Print Format | 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_PrintFormatChild_ID numeric(10) Table |
| Image Field | Image Field | The image is retrieved from the data column | The Image URL is retrieved from the data column | IsImageField character(1) NOT NULL Yes-No |
| Image attached | Afbeelding bijgevoegd | 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. | ImageIsAttached character(1) NOT NULL Yes-No |
| Image URL | Afbeelding 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. | ImageURL character varying(120) URL |
| Area | Area | Print Area | Print area of this item | PrintAreaType character(1) NOT NULL List |
| Barcode Type | Barcode Type | Type of barcode | null | BarcodeType character(3) List |
| Relative Position | Relative Position | The item is relative positioned (not absolute) | The relative positioning of the item is determined by X-Z space and next line | IsRelativePosition character(1) NOT NULL Yes-No |
| Set NL Position | 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. |
IsSetNLPosition character(1) NOT NULL Yes-No |
| X Position | X Position | Absolute X (horizontal) position in 1/72 of an inch | Absolute X (horizontal) position in 1/72 of an inch | XPosition numeric(10) NOT NULL Integer |
| Y Position | Y Position | Absolute Y (vertical) position in 1/72 of an inch | Absolute Y (vertical) position in 1/72 of an inch | YPosition numeric(10) NOT NULL Integer |
| Next Line | Volgende Regel | Print item on next line | If not selected, the item is printed on the same line | IsNextLine character(1) NOT NULL Yes-No |
| Next Page | Volgende Pagina | The column is printed on the next page | Before printing this column, there will be a page break. | IsNextPage character(1) NOT NULL Yes-No |
| Below Column | 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. | BelowColumn numeric(10) Integer |
| Line Alignment | Line Alignment | Line Alignment | For relative positioning, the line alignment | LineAlignmentType character(1) NOT NULL List |
| Field Alignment | 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 | FieldAlignmentType character(1) NOT NULL List |
| X Space | 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. | XSpace numeric(10) NOT NULL Integer |
| Y Space | 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. | YSpace numeric(10) NOT NULL Integer |
| Max Width | 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. | MaxWidth numeric(10) NOT NULL Integer |
| Fixed Width | Fixed Width | Column has a fixed width | The Column has a fixed width, independent from the content | IsFixedWidth character(1) NOT NULL Yes-No |
| Shape Type | Shape Type | Type of the shape to be painted | null | ShapeType character(1) List |
| Max Height | 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. | MaxHeight numeric(10) NOT NULL Integer |
| One Line Only | 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. | IsHeightOneLine character(1) NOT NULL Yes-No |
| Fill Shape | Fill Shape | Fill the shape with the color selected | null | IsFilledRectangle character(1) NOT NULL Yes-No |
| Print Color | Print Kleur | Color used for printing and display | Colors used for printing and display | AD_PrintColor_ID numeric(10) Table Direct |
| Print Font | Print Lettertype | Maintain Print Font | Font used for printing | AD_PrintFont_ID numeric(10) Table Direct |
| Arc Diameter | Arc Diameter | Arc Diameter for rounded Rectangles | Width of the horizontal/vertical diameter of the arc at the four corners | ArcDiameter numeric(10) Integer |
| Order by | Sorteer op | 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. | IsOrderBy character(1) NOT NULL Yes-No |
| Record Sort 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) |
SortNo numeric(10) NOT NULL Integer |
| Descending | Descending | Sort your data using a SQL Desc Order By statement | null | IsDesc character(1) NOT NULL Yes-No |
| Group by | 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. | IsGroupBy character(1) NOT NULL Yes-No |
| Page break | Page break | Start with new page | Before printing this item, create a new page | IsPageBreak character(1) NOT NULL Yes-No |
| Calculate Sum (Σ) | 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. | IsSummarized character(1) NOT NULL Yes-No |
| Running Total | 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. | IsRunningTotal character(1) NOT NULL Yes-No |
| Calculate Count (№) | Calculate Count (№) | Count number of not empty elements | Calculate the total number (№) of not empty (NULL) elements (maximum is the number of lines). | IsCounted character(1) NOT NULL Yes-No |
| Running Total Lines | 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. | RunningTotalLines numeric(10) Integer |
| Calculate Minimum (↓) | Calculate Minimum (↓) | Calculate the minimum amount | Calculate the Minimum (↓) of the data if the field is numeric, otherwise minimum length of the field. | IsMinCalc character(1) NOT NULL Yes-No |
| Calculate Maximum (?) | Calculate Maximum (?) | Calculate the maximum amount | Calculate the Maximum (↑) of the data if the field is numeric, otherwise maximum length of the field. | IsMaxCalc character(1) NOT NULL Yes-No |
| Calculate Mean (μ) | 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. | IsAveraged character(1) NOT NULL Yes-No |
| Calculate Variance (σ²) | Calculate Variance (σ²) | Calculate Variance | The Variance (σ²) is the a measure of dispersion - used in combination with the Mean (μ) | IsVarianceCalc character(1) NOT NULL Yes-No |
| Calculate Deviation (σ) | Calculate Deviation (σ) | Calculate Standard Deviation | The Standard Deviation (σ) is the a measure of dispersion - used in combination with the Mean (μ) | IsDeviationCalc character(1) NOT NULL Yes-No |
TAB: Item Translation
Beschrijving: Print Format Translation
Help null
Bestand:Printformaat - Item Translation - Venster (iDempiere 1.0.0).png
| Naam | Naam | Beschrijving | Help | Specificaties |
|---|---|---|---|---|
| Client | 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_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 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_Org_ID numeric(10) NOT NULL Table Direct |
| Print Format Item | Print Format Item | Item/Column in the Print format | Item/Column in the print format maintaining layout information | AD_PrintFormatItem_ID numeric(10) NOT NULL Table Direct |
| Language | Taal | Language for this entity | The Language identifies the language to use for display and formatting | AD_Language character varying(6) NOT NULL Table |
| Active | Actief | 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. |
IsActive character(1) NOT NULL Yes-No |
| Translated | Vertaald | This column is translated | The Translated checkbox indicates if this column is translated. | IsTranslated character(1) NOT NULL Yes-No |
| Name | 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. | Name character varying(60) NOT NULL String |
| Print Text | 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. | PrintName character varying(2000) String |
| Print Label Suffix | 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. | PrintNameSuffix character varying(60) String |
TAB: Graph
Beschrijving: Define Graph to be included
Help null
Bestand:Printformaat - Graph - Venster (iDempiere 1.0.0).png
| Naam | Naam | Beschrijving | Help | Specificaties |
|---|---|---|---|---|
| Graph | Graph | Graph included in Reports | Pie/Line Graph to be printed in Reports | AD_PrintGraph_ID numeric(10) NOT NULL ID |
| Client | 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_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 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_Org_ID numeric(10) NOT NULL Table Direct |
| Print Format | Print Format | Data Print Format | The print format determines how data is rendered for print. | AD_PrintFormat_ID numeric(10) NOT NULL Table Direct |
| Name | 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. | Name character varying(60) NOT NULL String |
| Description | Beschrijving | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) String |
| Active | Actief | 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. |
IsActive character(1) NOT NULL Yes-No |
| Graph Type | Graph Type | Type of graph to be painted | Type of graph to be painted | GraphType character(1) NOT NULL List |
| Description Column | Beschrijving Kolom | Description Column for Pie/Line/Bar Charts | Graph Description Column for Pie and Line/Bar Charts | Description_PrintFormatItem_ID numeric(10) NOT NULL Table |
| Data Column | Data Column | Data Column for Pie and Line Charts | Graph Data Column for Pie and Line/Bar Charts | Data_PrintFormatItem_ID numeric(10) NOT NULL Table |
| Data Column 2 | Data Column 2 | Data Column for Line Charts | Additional Graph Data Column for Line/Bar Charts | Data1_PrintFormatItem_ID numeric(10) Table |
| Data Column 3 | Data Column 3 | Data Column for Line Charts | Additional Graph Data Column for Line/Bar Charts | Data2_PrintFormatItem_ID numeric(10) Table |
| Data Column 4 | Data Column 4 | Data Column for Line Charts | Additional Graph Data Column for Line/Bar Charts | Data3_PrintFormatItem_ID numeric(10) Table |
| Data Column 5 | Data Column 5 | Data Column for Line Charts | Additional Graph Data Column for Line/Bar Charts | Data4_PrintFormatItem_ID numeric(10) Table |
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}