Skip to main content

Window: Print Table Format

[Created: 24/08/2002 - Updated: 02/01/2000 ]
Description: Define Report Table Format
Help: The Print Table Format lets you define how table header, etc. is printed. Please note that the Report Table FOrmat is cached to improve performance.

Tab: Print Table Format

[Created: 24/08/2002 - Updated: 02/01/2000 ]
Description: Define Report Table Format
Help: The Print Table Format lets you define how table header, etc. is printed. If you leave the entries empty, the default colors and fonts are used:Fonts are based on the Font used in the Report; Page Header and Table Header will be bold, the Function Font is Bold-Italic, the Footer Font is two points smaller, the Parameter Font is Italic.
Tab Level: 0

Table 10: Print Table Format - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_printtableformat.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_printtableformat.AD_Org_ID numeric(10)
Table Direct
NameAlphanumeric identifier of the entityThe 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_printtableformat.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_printtableformat.Description character varying(255)
String
ActiveThe record is active in the systemThere 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_printtableformat.IsActive character(1)
Yes-No
DefaultDefault valueThe Default Checkbox indicates if this record will be used as a default value.ad_printtableformat.IsDefault character(1)
Yes-No
Header Row ColorForeground color if the table header rowTable header row foreground colorad_printtableformat.HdrTextFG_PrintColor_ID numeric(10)
Table
Header Row BG ColorBackground color of header rowTable header row background colorad_printtableformat.HdrTextBG_PrintColor_ID numeric(10)
Table
Header Row FontHeader row FontFont of the table header rowad_printtableformat.Hdr_PrintFont_ID numeric(10)
Table
Multi Line HeaderPrint column headers on multiple lines if necessary.If selected, column header text will wrap onto the next line -- otherwise the text will be truncated.ad_printtableformat.IsMultiLineHeader character(1)
Yes-No
Paint Header LinesPaint Lines over/under the Header LineIf selected, a line is painted above and below the header line using the stroke informationad_printtableformat.IsPaintHeaderLines character(1)
Yes-No
Header Line ColorTable header row line colorColor of the table header row linesad_printtableformat.HdrLine_PrintColor_ID numeric(10)
Table
Header Stroke TypeType of the Header Line StrokeType of the line printedad_printtableformat.HdrStrokeType character(1)
List
Header StrokeWidth of the Header Line StrokeThe width of the header line stroke (line thickness) in Points.ad_printtableformat.HdrStroke numeric
Number
Paint Vertical LinesPaint vertical linesPaint vertical table linesad_printtableformat.IsPaintVLines character(1)
Yes-No
Paint Horizontal LinesPaint horizontal linesPaint horizontal table linesad_printtableformat.IsPaintHLines character(1)
Yes-No
Paint Boundary LinesPaint table boundary linesPaint lines around tablead_printtableformat.IsPaintBoundaryLines character(1)
Yes-No
Line ColorTable line colorad_printtableformat.Line_PrintColor_ID numeric(10)
Table
Line Stroke TypeType of the Line StrokeType of the line printedad_printtableformat.LineStrokeType character(1)
List
Line StrokeWidth of the Line StrokeThe width of the line stroke (line thickness) in Points.ad_printtableformat.LineStroke numeric
Number
Print Function SymbolsPrint Symbols for Functions (Sum, Average, Count)If selected, print symbols - otherwise print names of the functionad_printtableformat.IsPrintFunctionSymbols character(1)
Yes-No
Function ColorFunction Foreground ColorForeground color of a function rowad_printtableformat.FunctFG_PrintColor_ID numeric(10)
Table
Function BG ColorFunction Background ColorBackground color of a function rowad_printtableformat.FunctBG_PrintColor_ID numeric(10)
Table
Function FontFunction row FontFont of the function rowad_printtableformat.Funct_PrintFont_ID numeric(10)
Table
Image attachedThe image to be printed is attached to the recordThe image to be printed is stored in the database as attachment to this record. The image can be a gif, jpeg or png.ad_printtableformat.ImageIsAttached character(1)
Yes-No
Image URLURL of imageURL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png.ad_printtableformat.ImageURL character varying(120)
URL
ImageImage or IconImages and Icon can be used to display supported graphic formats (gif, jpg, png).You can either load the image (in the database) or point to a graphic via a URI (i.e. it can point to a resource, http address)ad_printtableformat.AD_Image_ID numeric(10)
Table Direct