Reports with Multiple Fields in One Column

    This procedure will allow multiple fields to appear under one 
column heading rather than in separate columns across the page.

    For example, if you want an address block to appear in one column 
of a report:

       Name & Address             Telephone                etc.
    ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ       ÄÄÄÄÄÄÄÄÄÄÄÄÄÄ
     John Smith                   303-123-5678
     The USA Company
     123 Main Street
     Anytown, State 00000

    Make all the fields you wish to have in one column invisible. 
Enter the following Column/Sort Specs:

    FIRST NAME: 1,I          LAST NAME: 2,I,AS        TELEPHONE: 10
    COMPANY: 3,I
    ADDRESS: 4,I
    CITY: 5,I      STATE: 6,I     ZIP: 7,I    Note: Zip field must be 
                                               text field not numeric.

    Then create two Derived Columns:

    Heading:
    Formula: @Text (30, " ")
    Column Spec: 8,I

    Heading: 30:Name & Address
    Formula: #1+" "+ #2+ #8+ #3+ #8+ #4+ #8+ #5+ ", "+ #6+ "  " + #7
    Column Spec: 9,AS

    PROGRAMMING  EXPLANATION

    By adding 30 blank spaces after each field and then limiting the 
width of the derived column, we can force the text of each field to 
wrap underneath on consecutive lines.

    For wider or narrower columns, change the value of 30 in the two
derived columns to the desired column width.

    The maximum length of the Address block, including added spaces is 
512 characters.












Q & A Application Note       Rev. 6/92           #2209     Page 1 of 1