Skip to content

Report Desk: Column Formatting

Release Date: 4/28/23
Elliott Version 8.6

Changing Column Format

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


Column Format Types

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. Also see explanation with D.

C0 to C6

Display in currency format with the specified number of decimals, negative numbers in parentheses. Also see explanation with N0 to N6.

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.  It is used to represent integers with a specified number of characters, providing leading zeroes if needed. See further explanation of D1 to D9 below.  You can also reference the following link for more details https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings#DFormatString

D1 to D9

Display in digits format, showing the specified number of digits. E.g. "00001234" formatted as D6 would result in "001234". "00001234.123" formatted as D6 would cause an exception because it does not know how to  handle the decimal points. So it is used to represent integers with a specified number of characters, providing leading zeroes if needed.  If you are not sure if the value will have a decimal point, you should use N0 to N6 to avoid potential error.

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. See further explanation in N0 to N6 below.

N0 to N6

Display in number format, using thousands separator and decimal point, with the specified number of decimals. E.g. "00001234.123" formatted as N2 will result in "1,234.12".

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 ; negative numbers in parentheses.

$0 to $6

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

Additional Properties (Detail Lines)

More formatting options are available by clicking on the Information image in the last column of it's row in the grid.  When you do that, the following options will appear:


The options available above are described here:
  • Suppress Duplicates: If the previous row contains the same value as the current row, it will not be printed.
  • Preserve format for CSV/XLSX output: Sometimes a numeric number, like "000000" will become simply "0" when exported to XLSX or CSV format.  Checking this box ensures that the value will be exported as a string instead, preserving the original value.
  • Special formatting for negative numbers: For some reports, typically related to General Ledger, negative numbers, like "-123.45", should be displayed as "123.45 CR".  Selecting "CR for Credits" accomplishes this.
Updating Aggregates (Group Footers and Report Footer)
When the column is in a Group or Report Footer, additional formatting options are also available:


In addition to changing the aggregate, the following formatting options are available:
  • Use bold font: Display the value using a bold font.
  • Font size adjustment: This allows the value to be displayed in a larger or smaller font (in 0.25 point increments) than the detail amounts. 
  • Special formatting for negative numbers: Negative numbers, like "-123.45", can be displayed as "123.45 CR" by selecting "CR for Credits" here.

JEG
EL850RD, ELRW_SYRPTUDR

Feedback and Knowledge Base