Codeunit wDCR_ReportFunctions¶
Provides helper functions for reports.
Properties¶
Name | Value |
---|---|
Access | Public |
Methods¶
wgFncFormatDateText¶
Formats a date according to the format-option of the current report.
Parameters¶
Type | Name | Description |
---|---|---|
Date |
pDate |
The Date. |
Returns¶
Type | Description |
---|---|
Text |
The formatted date text. |
wgFncFormatDateText¶
Formats a date according to the format-option of the report with the specified ID.
Parameters¶
Type | Name | Description |
---|---|---|
Integer |
pReportID |
The Report ID. |
Date |
pDate |
The Date. |
Returns¶
Type | Description |
---|---|
Text |
The formatted date text. |
wgFncFormatDateText¶
Formats a date according to the specified format option.
Parameters¶
Type | Name | Description |
---|---|---|
Date |
pDate |
The date. |
Enum "wDCR_DateTextFormat" |
pwDCR_DateTextFormat |
The format option. |
Returns¶
Type | Description |
---|---|
Text |
The formatted date text. |
wgFncGetContactSalutationText¶
Returns a salutation text (formal or informal) for a contact based on the Salutation Settings for the contact. If the contact or salutation formula does not exist, then an empty string is returned.
Parameters¶
Type | Name | Description |
---|---|---|
Code[20] |
pContactNo |
The no. of the contact to get the salutation text for. |
Code[10] |
pLanguageCode |
The code of the language to use for the translation of the salutation. |
Enum "Salutation Formula Salutation Type" |
pSalutationType |
The type of salutation to use. |
Returns¶
Type | Description |
---|---|
Text |
The salutation text for the contact based on the passed parameters. |
wgFncGetContactSalutationText¶
Returns a salutation text (formal or informal) for a contact based on the Salutation Settings for the contact. If the contact or salutation formula does not exist, then the "pContactName" parameter will be returned.
Parameters¶
Type | Name | Description |
---|---|---|
Text |
pContactName |
The name of the contact to get the salutation text for. |
Code[20] |
pContactNo |
The no. of the contact to get the salutation text for. |
Code[10] |
pLanguageCode |
The code of the language to use for the translation of the salutation. |
Enum "Salutation Formula Salutation Type" |
pSalutationType |
The type of salutation to use. |
Returns¶
Type | Description |
---|---|
Text |
The salutation text for the contact based on the passed parameters. |
wgFncGetCurrencySymbol¶
Returns CurrencySymbol.
Parameters¶
Type | Name | Description |
---|---|---|
Code[10] |
pCurrencyCode |
The Currency Code. |
Returns¶
Type | Description |
---|---|
Text[10] |
The CurrencySymbol. |
wgFncGetDateTextFormat¶
Retrieves the format-option that should be used to format dates in a report with specified ID.
Parameters¶
Type | Name | Description |
---|---|---|
Integer |
pReportID |
The ID of the report. |
Enum "wDCR_DateTextFormat" |
vDateTextFormat |
The Format to use. |
Returns¶
Type | Description |
---|---|
Boolean |
true iff a date text format setting could be found for the report. |
wgFncGetDimText¶
Builds strings of Dimension Code and Dimension Value Code pairs from a set of Dimension Set Entry records. This procedure is meant to be used iterating over a record set, for example in the OnAfterGetRecord trigger of a Dimension Set Entry dataitem. It will result in a string formatted like: 'DimCode1 DimValueCode1, DimCode2 DimValueCode2, DimCode3 DimValueCode3'.
Parameters¶
Type | Name | Description |
---|---|---|
Record "Dimension Set Entry" |
vRecDimSetEntry |
The Dimension Set Entry dataitem. |
Text[120] |
vDimText |
The text build from the Dimension Set Entry records. |
wgFncGetItemAttributeNameByLanguageCode¶
Retrieves the Item Attribute Name for the specified Language Code.
Parameters¶
Type | Name | Description |
---|---|---|
Record "Item Attribute Value" |
pRecItemAttributeValue |
The Item Attribute Value record. |
Code[10] |
pLanguageCode |
The Language Code. |
Returns¶
Type | Description |
---|---|
Text[250] |
The Item Attribute Name for the specified Language Code. |
wgFncGetItemAttributeValueByLanguageCode¶
Retrieves the Item Attribute Value for the specified Language Code.
Parameters¶
Type | Name | Description |
---|---|---|
Record "Item Attribute Value" |
pRecItemAttributeValue |
The Item Attribute Value record. |
Code[10] |
pLanguageCode |
The Language Code. |
Returns¶
Type | Description |
---|---|
Text[250] |
The Item Attribute Value for the specified Language Code. |
wgFncGetReportIDFromCurrReportObjectIDString¶
Retrieves the Report ID from the string returned by CurrReport.ObjectId(false)
Parameters¶
Type | Name | Description |
---|---|---|
Text |
pCurrReportObjectID |
The output of CurrReport.ObjectId(false). |
Returns¶
Type | Description |
---|---|
Integer |
The Report ID. |
wgFncHideLineDiscount¶
Determines whether or not the Line Discount column needs to be shown on the document. Checks whether there are any lines under the document that have a line discount. If there are no lines with a discount, then the return value will be true
. The procedure should be able to check this for the following header tables:
-
Sales Headers
-
Sales Shipment Headers
-
Sales Invoice Headers
-
Sales Credit Memo Headers
-
Return Receipt Headers
-
Service Headers
-
Service Invoice Headers
-
Service Credit Memo Headers
-
Service Shipment Headers
-
Purchase Headers
-
Purchase Invoice Headers
-
Purchase Credit Memo Headers
-
Purchase Receipt Headers
-
Return Shipment Headers For any other unsupported record type the return value is "true".
Parameters¶
Type | Name | Description |
---|---|---|
RecordRef |
vRecRef |
The header record |
Returns¶
Type | Description |
---|---|
Boolean |
true iff there are no lines in the document with a line discount. |
wgFncIsMonolithicVAT¶
Determines whether a set of VAT Amount Line records only apply to a single VAT type. If the record set only includes 0 or 1 records, or 2 records being a positive and negative line for the same VAT type, then the return value will be true, because there is only a single VAT type.
Parameters¶
Type | Name | Description |
---|---|---|
Record "VAT Amount Line" |
vRecVATAmountLine |
The set of VAT Amount Line records. |
Returns¶
Type | Description |
---|---|
Boolean |
true iff only a single VAT type exists in the VAT Amount Line record set. |
wgFncIsUseShowCommentsAndDimensionsEnabled¶
Gets the value of field "Use "Show Comments" and "Show Dimensions" from the setup.
Returns¶
Type | Description |
---|---|
Boolean |
The value of "Use "Show Comments" and "Show Dimensions". |
wgFncSetReportID¶
Sets the Report ID for this codeunit.
Parameters¶
Type | Name | Description |
---|---|---|
Integer |
pReportID |
The report ID. |
wgFncSetReportIDFromCurrReportObjectIDString¶
Sets the Report ID for this codeunit from the string returned by CurrReport.ObjectId(false)
Parameters¶
Type | Name | Description |
---|---|---|
Text |
pCurrReportObjectID |
The output of CurrReport.ObjectId(false). |
Returns¶
Type | Description |
---|---|
Integer |
The Report ID. |
wgFncShouldLoadItemPictures¶
Retrieves whether item pictures should be loaded for the current report.
Returns¶
Type | Description |
---|---|
Boolean |
true iff item pictures are to be loaded. |
wgFncShouldLoadItemPictures¶
Retrieves whether item pictures should be loaded for the report with the specified ID.
Parameters¶
Type | Name | Description |
---|---|---|
Integer |
pReportID |
The Report ID. |
Returns¶
Type | Description |
---|---|
Boolean |
true iff item pictures are to be loaded. |
wgFncShouldOverrideDocumentLanguage¶
Retrieves whether the document language should be determined by parameters set on the request page, "Report Limits and Settings" page and/or session language instead of using the "Language Code" field on the document header.
Returns¶
Type | Description |
---|---|
Boolean |
true if the document language code should be overriden by specifically set parameters. |
wgFncShouldOverrideDocumentLanguage¶
Retrieves whether the document language should be determined by parameters set on the request page, "Report Limits and Settings" page and/or session language instead of using the "Language Code" field on the document header.
Parameters¶
Type | Name | Description |
---|---|---|
Integer |
pReportID |
The ID of the report object. |
Returns¶
Type | Description |
---|---|
Boolean |
true if the document language code should be overriden by specifically set parameters. |
wlEvpOnBeforeFormatDateText¶
Allows to hook into how dates are formatted to text.
Parameters¶
Type | Name | Description |
---|---|---|
Date |
pDate |
The date. |
Enum "wDCR_DateTextFormat" |
pwDCR_DateTextFormat |
The date format that should be used. |
Text |
vFormattedDateText |
The output (date formatted as text). |
Boolean |
vIsHandled |
Set this parameter to true if your extension handled formatting the date as text. |
wlEvpOnAfterHideLineDiscount¶
Allows to hook into the behaviour of the wgFncHideLineDiscount procedure that is used by report objects to determine if there is any line discount in the documents and whether the Line Discount % header label should be hidden.
Parameters¶
Type | Name | Description |
---|---|---|
RecordRef |
vRecRef |
The header record |
Boolean |
vHideLineDiscount |
Whether there are no lines in the document with a line discount. |
Boolean |
vIsHandled |
This parameter specifies whether there was an implementation that handled the header record type. |