Mailmerge and duplicate pipeline names

rbuser

I have found that when using mailmerge and referencing a dataset that is not
the primary dataset for the report and there is more than one pipeline with
the same name on different active forms the mailmerge uses the first
pipeline created not the latest pipeline created.
In the following mailmerge example if there is more than one active form
with a pipeline named 'AccountPL' then the merged data will not be extracted
from the current pipeline.

Balance_Due

The workaround I have used is to ensure that all active forms with
potentially duplicate pipeline names are freed when loading the current
form. This is not a desireable solution and I cannot use different pipeline
name since the report could be run from several active form.

Would it be possible for the ReportBuilder engine to select the pipeline
created by the currently active form?

Regards, Ray

nicocizik

Hi Ray,

This is fundamental to the way pipelines are designed to work. When a
pipeline is accessed, a list is created with all pipelines on any
forms/datamodules in the project and the first match is taken and used.

Solutions are to ensure all pipelines have a unique name, free non-active
forms (like you are currently doing), or toggle the visibility of the
un-needed pipelines before performing the mailmerge.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com