Combining fields

Last updated:

    Overview

    This section explains how to combine the contents of two fields so that the result is displayed in one field in the PDF.

    Combining fields

    In this example, the DX Address and DX Number fields are added together for formatting purposes only in certain forms, for example, the presenter’s name and address in some Companies House forms:

    File:test/insolvency/230_21+PDF+templates/090_Additional+Steps/020_Adding+two+fields+together/PDF_AddFields.png

    In the listing shown below, the Practice DX Number is appended to the Practice DX Address.

    INSERT INTO @Data
    SELECT  'DX' ,
            'DX: '
            + ( SELECT  n.Number
                FROM    Practice_Number pn
                        INNER JOIN Number n ON pn.NumberID = n.NumberID
                        INNER JOIN Admin a ON pn.PracticeID = a.PracticeID
                WHERE   ( n.NumberTypeID = 7 )
                        AND ( a.AdminID = @AdminID )
              )
            + ' '
            + ( SELECT  UPPER(n.Number)
                FROM    Practice_Number pn
                        INNER JOIN Number n ON pn.NumberID = n.NumberID
                        INNER JOIN Admin a ON pn.PracticeID = a.PracticeID
                WHERE   ( n.NumberTypeID = 8 )
                        AND ( a.AdminID = @AdminID )
              )