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

Subreport

edited January 2007 in Datapipelines
Greeting,
I have problem producing report list from 2 files, please help.

1) I have 2 files.
2) First file: all records need to be printed until eof
3) Second file: all record need to be printed until eof
4) Second file will start printing right after the First file is finish
print the record.
5) First record of second file will print on bottom of last record of first
file.
--
6) In Main page, I put subreport in the summary band to print the second
file
7) In Subreport page, I put all field of second file in detail band

Problem:
Second file, only print 1 record (first record) and then the report finish.

Please advice....how to print all record in the second file ?

Comments

  • edited January 2007
    Hi Ed,

    Be sure you are connecting the subreport to the proper datapipeline. If
    this report is not connected, it will not traverse the data and will only
    give you the first record.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited January 2007
    Hi,

    I have connected the subreport detail band to datapipeline,
    but subreport still print first record only
    --
    If I put subreport on the main detail band then "first record of second
    file" gets printed on each record of first file, which I do not want.
    I think I have put the subreport on summary band is correct, but why only
    print 1 record of second file ?
    --
    How to solve this, or any other method of doing this ?



  • edited January 2007
    Hi Ed,

    Below are some items to check to be sure your environment is set up
    properly.

    1. Place the subreport in the summary band.
    2. Be sure the SummaryBand.PrintHeight is set to phDynamic.
    3. Be sure the DBText component inside the subreport is inside the detail
    band.
    4. Be sure the subreport and the DBText component are connected to the same
    (correct) datapipeline.
    5. Be sure the dataset connected to the subreport actually contains the
    amount of data you expect.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.