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

mailmerge, subreport problem

edited November 2004 in General
I will print 3 pages for a group of records. The sample data is as follows:
CUSTA,NAMEA,1,100
CUSTA,NAMEA,2,200
CUSTA,NAMEA,3,500
CUSTA,NAMEA,4,100
CUSTB,NAMEB,1,100
CUSTC,NAMEC,1,100

Expected output:
1st page:
=======

CUSTA
....
....

2nd page:
========

NAMEA
....
....

3rd page:
=======

CUSTA
NAMEA

1 100
2 200
3 500
4 100
----------
900

and so on.

I create a group (CUST) in the"MAIN" page. I put 2 subreports (1 TppRichText
on each subreport for mailmerge) on the Group Header and 1 on Detail band.
Question:
1. What should be their settings on Tppsubreport.PrintBehavior?
2. For the output page 1 and 2, my report output always gets CUSTA (no
CUSTB, CUSTC output)? it is ok on page 3.
3. Can I put a page break in TppRichText? so that 1 TppRichText is enough in
my case?
4. I know there is some limitation for mailmerge in the area of data
pipeline. Pls. give me more details.

Pls. give me hints on how to solve my problems.
Benson Wong
D5, RB6.03

Comments

  • edited November 2004
    Hi Benson,

    1. If you would like each of these subreport to remain on their own page,
    try setting them as Section style subreports.

    2. Remember that if you do not have the pipeline connected to the specific
    repor/subreport you are viewing, the data will not automatically traverse.
    Be sure your subreports are connected to the proper datasource.

    3. There is no way to add a page break inside a TppRichText in
    ReportBuilder.

    4. With the verson of RB you are using, the mail merge is limited to only
    accessing values from the datapipeline connected to the parent report. The
    latest version of ReportBuilder (RB 9) allows you to connect to multiple
    separate pipelines within the same richtext component.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited November 2004
    > > 2. For the output page 1 and 2, my report output always gets CUSTA (no
    Question
    1. For what reason do my report output just gets CUSTA (on all the pages),
    no CUSTB or CUSTC on 2nd page?
    2. When do the mailmerge rendering process? any difference if I put the
    subreports on group-header band or detail band?
    3. If I set the subreport to "Section style", where should I put the
    TppRIchText in? in Title/detail/summary/footer?

    Pls. help.
    Benson.


This discussion has been closed.