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

Is this mail merge scenario possible?

edited June 2001 in General
I'm trying to use ReportBuilder to replace an OLE-to-MSWord application.
Here are some of the requirements of the system:

1. All documents need to be printed in one batch (printing to a large
mainframe printer which must print all pages in one spool job)

2. Each document can be multiple pages
3. Header information needs to be repeated on subsequent pages of a
document
4. Each document in the merge needs to be saved separately to a file
(ideally using TExtraDevices to PDF)
5. Fields from the dataset need to be integrated into the documents, but
paragraphs within the document need to be conditionally displayed based on
values in the data.

I'm just curious if each of these requirements is possible in RB before I
jump into it.

Thanks.

Terry Mihm

Comments

  • edited June 2001
    Hi,

  • edited June 2001
    Ron,

    Thanks for the info.

    With regards to the following, I was thinking of having literal text (memos
    or rtf memos) in the report, with event handlers to determine if they should
    be printed for that document or not. I have 32 flags which indicate which
    of 32 paragraphs should be printed. Maybe event handlers don't work the
    same in a mail-merge scenario. My other option is to have the paragraph
    contents stored in a separate table (which would provide the added benefit
    of letting users update the contents), but it seems I'd still need the
    ability to dynamically inspect values at runtime and conditionally query for
    the required paragraphs.

    but
    on

    Thanks again.
  • edited June 2001
    Hi,

    I do the second option where I store the queried results into a Memory Table and
    print a subreport from it. Mailmerge works in such a case.

    enjoy,
    Ron.

  • edited June 2001
    The RBAddOn component set supports nested mail merge fields. You could
    therefore build an outline that merged in the relevant paragraphs. A simple
    example of this is part of the demo available on the downloads page at
    http://www.bancoems.com/rbaddon.htm.

    ------------------------------------
    Bruce Roberts
    Roberts Browne Limited
    RBAddOn Components for Report Builder
    http://www.bancoems.com/rbaddon.htm
This discussion has been closed.