WinVask -  Faktura

How To: Combine Text And Database Fields

How To: Combine Text And Database Fields

Previous topic Next topic  

How To: Combine Text And Database Fields

Previous topic Next topic  

 

Problem:  Your report page needs to combine freeform text and database field information on the same line.

 

Solution:  After adding a new frame to the report page double left click the frame to display the Frame Properties window. Inside the Contents entry field you can add the text that you want to display, a blank space after that text, an Ampersand (&) character, another blank space, and then the desired database field.

 

Example 1

Combine the text "Vendor Name:" and the database field INV:Vendor. The Frame Properties Window entry field would resemble this:

 

'Vendor Name: ' & INV:Vendor

 

Example 2

Combine the text 'Vendor Name:' and two database fields (INV:Lastname, INV:FirstName) that contain the first and last name of the vendor. You want the output to be formatted as the last name and then the first name, separated by a comma symbol. You also want to make sure that the database fields don't print extra blank spaces to avoid the output from looking odd (ex: Daughtry    , Scott). The Frame Properties Window entry field would resemble this:

 

'Vendor Name: ' & clip(INV:LastName) & ', ' & CLIP(INV:FirstName)