[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 .Fields

   This command informs dbReport that fields declarations of the fields
   to be used in the report are following.  The names of these fields
   must match the names as defined in the Data Dictionary array passed
   to dbReport. You are not required to declare all the fields passed to
   dbReport, only those you will be using.

   Example
     .Fields
     FirstName     01
     LastName      02
     Street        03
     City          04
     Province      05
     Country       06
     Married       07   [Married/Single]
     HiredDate     08   [MON DD, YY]

   The numbers following the field names are not required, they are
   there for reference only.  The fields in the actual format of the
   report are referred to by number.  Having the number here makes it
   easier when setting up the report format.

   For logical and date fields you can also define a mask that will
   determine how the output for that field will look.  The mask must be
   enclosed in the "[" and "]" characters.

   For a logical field you can define the output for a TRUE or FALSE
   condition.  The definitions for the true and false strings must be
   separated by a "/".

   Example
     .Fields
     Married     [Yes/No]
     or
     Married     [Married/Single]
     or
     InStock     [In Stock/Out of Stock]

     Other possibilities include (but are not limited to);
       [True/False]
       [.t./.f.]
       [ON/OFF]

   For a date field you can define the format to display the date value.

   Example
     .Fields
     HiredDate     [DD/MM/YY]
     or
     HiredDate     [DD MON YYYY]
     or
     HiredDate     [DAY MONTH DD, YYYY]

   If any of the following strings are found in a date mask they will be
   converted in the following manner.  All other characters will be
   printed as is (as in the case of the "/", ",", and space).

   YYYY  - Full year                  (1992, 1993, etc.)
   YY    - Last two digits of year    (92, 93, etc.)
   MONTH - Full month                 (January, February, etc.)
   MON   - Abbreviation of month      (Jan, Feb, etc.)
   MM    - Month in digits            (01, 02, etc.)
   DD    - Date                       (29, 30, 31, etc.)
   DAY   - Full day                   (Monday, Tuesday, etc.)
   DA    - Abbreviation of day        (Mon, Tue, etc.)
.

This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson