Report Desk: Column Formats

Release Date: TBD
Elliott Version 8.6

When you are in the Report Desk designer and you drag a column to the Where grid or one of the Line grids, a default format will appear.  You may change the format of the column to another type by clicking the down symbol in the grid.  When you do that, you will be presented with a list of compatible  formats for that column, depending on its data type:


Similarly, when you use the $$Format(<value>,<format>) function, you must enter a compatible <format> for the data <value>.

Below is a list of the recognized formats and their descriptions:

Format

Description

AcctNo

Display a 24-digit account number based on Company setup.

For example, if the company uses 4-digit main account and 2-digit profit center, then the value 000012340000005600000000 would be displayed as 1234-56.

AcctMain

Display just the main part of the account number, based on Company setup.

Accum

Display in default number format, with thousands separator and the number of decimals specified in the Company record for accumulated totals.

AccumZ

Display in default number format, with thousands separator and the number of decimals specified in the Company record for accumulated totals, except that a value of zero will not display.

C

Display using default currency format; negative numbers in parentheses.

C0 to C6

Display in currency format with the specified number of decimals.

Cost

Display in default number format, with thousands separator and the number of decimals specified in the Company record for cost fields.

CostZ

Display in default number format, with thousands separator and the number of decimals specified in the Company record for cost fields, except that a value of zero will not display.

CustNo

Display as a customer number – right-justified and zero filled if numeric; otherwise left-justified.

Bool

Display as Y or N, depending on whether the value is True or False

D

Display in default digits format, using numeric digits only.

D1 to D9

Display in digits format, showing the specified number of digits.

Date-6

Display a date in MM/DD/YY format.

Date-8

Display a date in MM/DD/YYYY format.

DocNo

Display as a document number – right-justified and zero filled if numeric; otherwise left-justified.

Email

Display left justified, removing any left- or right-brackets ( [ or ] ).

FedID

Display in federal identification number format: nn-nnnnnnn.

File

Display without any formatting.

GLEntity

Display the last two parts of an account number, separated by a dash.

GLEntityZ

Display the last two parts of an account number, separated by a dash, except that nothing is displayed if the last two parts of the account number are zeroes or spaces.

ItemNo

Display as an item number – left-justified.

N

Display in default number format, using thousands separator and decimal point.

N0 to N6

Display in number format, using thousands separator and decimal point, with the specified number of decimals.

PONo

Display as a two-part purchase order number, separated by a dash.

PO25

Display left-justified with no additional formatting.

Price

Display in default number format, with thousands separator and the number of decimals specified in the Company record for price fields.

PriceZ

Display in default number format, with thousands separator and the number of decimals specified in the Company record for price fields, except that a value of zero will not display.

Quantity or Qty

Display in default number format, with thousands separator and the number of decimals specified in the Company record for quantity fields.

QuantityZ or QtyZ

Display in default number format, with thousands separator and the number of decimals specified in the Company record for quantity fields, except that a value of zero will not display.

SlmNo

Display as a salesperson number – right-justified and zero filled if numeric; otherwise left-justified.

SSN

Display in Social Security number format: nn-nn-nnnn.

String

Display without any formatting.

Time-4

Display the hours and minutes as HH:MM.

Time-6

Display the hours, minutes and seconds as HH:MM:SS.

TrackNo

Display as a tracking number – left-justified.

UDR

Display without any formatting.

UPC

Display as a UPC number – left-justified.

VendNo

Display as a vendor  number – right-justified and zero filled if numeric; otherwise left-justified.

Z

Display in default number format, with thousands separator and decimal point, except that a value of zero will not display.

Z0 to Z6

Display in number format, with thousands separator and the specified number of decimals, except that a value of zero will not display.

ZipCd

Display left-justified, removing any left- or right-brackets ( [ or ] ).

$

Display in default currency format, except that a value of zero will not display.

$0 to $6

Display in currency format, showing the specified number of decimals, except that a value of zero will not display.

JEG
EL850RD, ELRW_SYRPTUDR

Feedback and Knowledge Base