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

Missing detailss in subreports

edited March 2007 in Subreports
I am trying to create a master-detail-detail report in RB 10.04 Professional
with Delphi 2005 and Advantage Local Server 8.1.

There are four tables total: the M-D-D set and an independent table tied to
the master. Detail-1 and Detail-2 nested together. Detail-1 is a header
table with just a few fields. Detail-2 is 2 columns of numbers with any
number of rows, usually between 5 and 10. There could be any number of
columns above 1, usually not more than 10 and often 4 or 5.

I have set it up to print the details as subreports in 5-across columns.
Detail 1 pipeline is in the Master detail band and Detail-2 is in the
Detail-1 detail band. The problem is that Detail-2 does not always print the
data correctly. Sometimes it will only print 5 rows of a 10-row column
before skipping to the next column, sometimes it will print the 6th column
on the next page and not print 7-10. Some Detail-2 data is skipped all
together. The report is consistent in that it always print wrong in the same
places with the same test data.

The tables are keyed as follows:
Master
M-ID (PK)

Detail-1
M-ID (PK)
D1-ID (PK)

Detail-2
M-ID (PK)
D1-ID (PK)
D2-ID (PK)

Comments

  • edited March 2007
    Hi Bill,

    Is your data set up so that the Master is linked to the Detail 1 which is
    linked to the Detail 2 dataset? If not, this may be the problem. If you
    have nested subreports as you describe you will need to set up your linking
    in the above manner. Also if you are not working in DADE, be sure your
    detail datasets are ordered on the linking field.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited March 2007
    Nico Cizik (Digital Metaphors) wrote:
    Nico,

    The master table is ordered on columns other than the key. I changed it
    to order on the key but it did not help. The detail tables are ordered
    on compound keys made up their primary keys. All of the tables are
    linked together in the pipelines by their primary keys.

    Bill
  • edited March 2007
    Hi Bill,

    If possible, please send a small example in .zip format to
    support@digital-metaphors.com that demonstrates the issue and I'll take a
    look at it for you.

    --
    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.