mailmerge, subreport problem
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
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
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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.