Missing detailss 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)
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)
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com