Combining fields

Last modified

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 )
          )
Page statistics
243 view(s) and 6 edit(s)
Social share
Share this page?

Tags

CCH Insolvency

Comments

You must to post a comment.

Attachments

 

 | Cookie Policy | Copyright | Privacy Policy Terms of Use | Contact Us |