Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Combining DBText

edited April 2003 in General
If I have two fields that I want adding together as one in a report, i.e.
address and zip/postcode so that they word wrap neatly.

What is the best way of doing this in RB6?

Ive had a look through the help files but they are not very clear.

Comments

  • edited April 2003
    Hi Andy,

    create a calculated field or use a 'TppVariable' component with some RAP code. The latter needs at least the Enterprise version.

    regards,
    Chris Ueberall;
  • edited April 2003
    Andy,

    Check out Demo 33 at \RBuilder\Demos\1. Reports\dm0033.pas. This demo shows
    how do perform an address merge in code. You may also merge one line using
    a TppVariable and data directly from the pipeline as Chris explained.

    MyVariable.Value := Report.DataPipeline['city'] + ' ' +
    Report.DataPipeline['state'];

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2003
    Thanks, that worked fine.
This discussion has been closed.