CS Time/TNA Documents

username password

Report Pictures


    Pictures are used when reading fields for reports. They govern the finer details of how the field can be displayed. There are different types of pictures for different types of fields.  For example, to display a Date field you would use a Date Picture, a Time field would use a Time picture etc.

     

    CONTENT

    String Pictures

    A string picture describes an unformatted string of a specific length.

     

    Format:     @Sn

    @S All string picture begin with @S.
    n Determines the number of characters in the picture format.

     

     

     

     

    Example:   @S20        A 20 character string length.

    Date Pictures

    The stored value is the number of days since December 28, 1800. The date picture token converts the value into one of the date formats.

     

    Format:     @Dn[s][B]

    @D All date pictures begin with @D.
    n Determines the date picture format. Date picture formats range from 1 through 18. A leading zero (0) indicates a zero filled day or month.
    s

    A separation character between the month, day, and year components. If omitted, the slash ( / ) appears.

    .   (period) Produces periods
    '   (grave accent) Produces commas
    -   (hyphen) Produces hyphens
    _   (underscore) Produces spaces
    B Specifies that the format displays as blank when the value is zero.

     

    Examples:

    Picture Format Result
    @D1 mm/dd/yy 10/1/59
    @D01 mm/dd/yy 10/01/59
    @D2 mm/dd/yyyy 10/1/1959
    @D3 mmm dd, yyyy OCT 1,1959
    @D4 mmmmmmmmm dd, yyyy October 1, 1959
    @D5 dd/mm/yy 1/10/59
    @D6 dd/mm/yyyy 1/10/1959
    @D7 dd mmm yy 1 OCT 59
    @D8 dd mmm yyyy 1 OCT 1959
    @D9 yy/mm/dd 59/10/1
    @D10 yyyy/mm/dd 1959/10/1
    @D11 yymmdd 59101
    @D12 yyyymmdd 1959101
    @D13 mm/yy 10/59
    @D14 mm/yyyy 10/1959
    @D15 yy/mm 59/10
    @D16 yyyy/mm 1959/10
    @D17   Windows Control Panel setting for Short Date
    @D18   Windows Control Panel setting for Long Date
    @D19 dd/mm 1/10
    @D20 ddmmyyyyy 1101959
    @D1. mm.dd.yy 10.1.59
    @D2- mm‑dd‑yyyy 10-1-1959
    @D5_ dd mm yy 1 10 59
    @D6' dd,mm,yyyy 1,10,1959

    Time Pictures

    The stored value is the number of hundredths of a second since midnight. The picture token converts the value to one of the time formats.

     

    Format:     @T-n[s][B]

    @T All time pictures begin with @T.
    - Optional. If included then negative numbers will be formatted as negative hours.
    n Determines the time picture format. Time picture formats range from 1 through 14. A leading zero (0) indicates zero‑filled hours.
    s

    A separation character. By default, colon ( : ) characters appear between the hour, minute, and second components of certain time picture formats. The following s indicators provide an alternate separation character for these formats.

    .   (period) Produces periods
    '   (grave accent) Produces commas
    -   (hyphen) Produces hyphens
    _   (underscore) Produces spaces
    B Specifies that the format displays as blank when the value is zero.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Examples:

    Picture Format Result
    @T1 hh:mm 7:30
    @T2 hhmm 730
    @T3 hh:mmXM 7:30AM
    @T03 hh:mmXM 07:30AM
    @T4 hh:mm:ss 7:30:00
    @T5 hhmmss 73000
    @T6 hh:mm:ssXM 7:30:00AM
    @T7   Windows Control Panel setting for Short Time
    @T8   Windows Control Panel setting for Long Time
    @T9 hh.hh Hours in decimal format i.e. 7.50 (0.5 = 30 mins)
    @T10 hhh:mm 123:45 - used for totals where hours can exceed 99:59
    @T11 hhhhh Hours in decimal format, with 2 decimal places, but no seperator e.g. 12375
    @T12 hhh.hh Hours in decimal format with 2 decimal places e.g. 123.75
    @T13 hhhh:mm 2345:30 - used for totals where hours can exceed 999:59
    @T14 hhhh.hh 2345.50 - hours in decimal format, with 2 decimal places where the total can exceed 999.99
    @T1. hh.mm 7.30
    @T1- hh-mm 7-30
    @T3_ hh mmXM 7 30AM
    @T4' hh,mm,ss 7,30,00

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Numeric and Currency Pictures

    The numeric and currency pictures format numeric values for screen display or in reports. If the value is greater than the maximum value the picture can display, a string of asterisks is displayed.

     

    Format:     @N [currency] [sign] [fill] n [grouping] [places] [sign] [currency] [B]

    @N All numeric and currency pictures begin with @N.
    currency Either a dollar sign ($) or a string constant enclosed in tildes (~). When it precedes the sign indicator and there is no fill indicator, the currency symbol "floats" to the left of the high order digit.  If there is a fill indicator, the currency symbol remains fixed in the left‑most position. If the currency indicator follows the size and grouping, it appears at the end of the number displayed.
    sign Specifies the display format for negative numbers. If a hyphen precedes the fill and size indicators, negative numbers will display with a leading minus sign. If a hyphen follows the size, grouping, places, and currency indicators, negative numbers will display with a trailing minus sign. If parentheses are placed in both positions, negative numbers will be displayed enclosed in parentheses. To prevent ambiguity, a trailing minus sign should always have grouping specified.
    fill Specifies leading zeros, spaces, or asterisks (*) in any leading zero positions, and suppresses grouping. If the fill indicator is omitted, leading zeros are suppressed.

    0   (zero) Produces leading zeros
    _   (underscore) Produces leading spaces
    *   (asterisk) Produces leading asterisks
    n The size is required to specify the total number of significant digits to display, including the number of digits in the places indicator and any formatting characters.
    grouping A grouping symbol, other than a comma (the default), can appear right of the size indicator to specify a three digit group separator. To prevent ambiguity, a hyphen grouping indicator should also specify the sign.

    .   (period) Produces periods
    -   (hyphen) Produces hyphens
    _   (underscore) Produces spaces
    places Specifies the decimal separator symbol and the number of decimal digits. The number of decimal digits must be less than the size. The decimal separator may be a period (.), grave accent (' ) (produces periods grouping unless overridden), or the letter "v" (used only for STRING field storage declarations not for display).

    .   (period) Produces a period
    '   (grave accent) Produces a comma
    v Produces no decimal separator
    B Specifies blank display whenever its value is zero.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Examples:

    Numeric Result Format
    @N9 4,550,000 Nine digits, group with commas (default)
    @N_9B 4550000 Nine digits, no grouping, leading blanks if zero
    @N09 004550000 Nine digits, leading zero
    @N*9 **455,000 Nine digits, asterisk fill, group with commas
    @N9_ 4 550 000 Nine digits, group with spaces
    @N9. 4.550.000 Nine digits, group with periods
    Decimal Result Format
    @N9.2 4,550.75 Two decimal places, period decimal separator
    @N_9.2B 4550.75 Two decimal places, period decimal separator, no grouping, blank if zero
    @N_9'2 4550,75 Two decimal places, comma decimal separator
    @N9.'2 4.550,75 Comma decimal separator, group with periods
    @N9_'2 4 550,75 Comma decimal separator, group with spaces

     

    Signed Result Format
    @N-9.2B -2,347.25 Leading minus sign, blank if zero
    @N9.2- 2,347.25- Trailing minus sign
    @N(10.2) (2,347.25) Enclosed in parenthesis when negative

     

    Dollar Currency Result Format
    @N$9.2B $2,347.25 Leading dollar sign, blank if zero
    @N$10.2- $2,347.25- Leading dollar sign, trailing minus when negative
    @N$(11.2) $(2,347.25) Leading dollar sign, in parenthesis when negative

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Int'l Result Format
    @N12_'2~F~ 1 5430,50 F France
    @N~L. ~12' L. 1.430.050 Italy
    @N~£~12.2 £1,240.50 United Kingdom
    @N~kr~12'2 kr1.430,50 Norway
    @N~DM~12'2 DM1.430,50 Germany
    @N12_'2~ mk~ 1 430,50 mk Finland
    @N~R~12.2 R1,240.50 South Africa

     

     

     

     

     

     

     

     

     

     

     

     

     


    Special Pictures

    There are two special pictures in the TNA report writer normally set as User type fields.

    @G1 - Defining a field with this picture will enable Employee Select in the Report Options. This field does not have a value.

    @C1 - Defining a field with this picture will create a tick box in the Report Options.  This field will have a value of 1 or 0.

     

     

    Permalink:  http://tinyurl.com/myqzmvc

    Page last modified 15:00, 8 Mar 2012 by Careen CS Time/TNA Documents > Reports > Writing Reports > Report Pictures

    Comments0

    You must login to post a comment.
    Attach file

    Files0

     
    Powered by MindTouch Core