Master-Detail-Detail
RB 7 Standard, Delphi7 Professional
I am new to RB and I think it is a fine product. I created this beautiful
report using 35 subreports and 35 sub-subreports. Everything displays
nicely except that after displaying two records from the subreport(which
could be one to ten), it then displays the sub-subreport records(which is
always one) and then the rest of the subreport records. I have reviewed the
Master Detail Detail tutorial, but I still can't seem to get it right.
subreport Properties:
BottomOffset=0
ExpandAll=False
KeepTogether=True
NewPrintJob=
CreateNode=True
OverFlowOffset=0
ParentPrinterSetup=True
ParentWidth=True
PrintBehavior=pbChild
ResetPageNo=True
TraverseAllData=False
sub-subreport Properties:
BottomOffset=0
ExpandAll=False
KeepTogether=True
NewPrintJob=
CreateNode=True
OverFlowOffset=0
ParentPrinterSetup=True
ParentWidth=True
PrintBehavior=pbChild
ResetPageNo=True
TraverseAllData=False
I am new to RB and I think it is a fine product. I created this beautiful
report using 35 subreports and 35 sub-subreports. Everything displays
nicely except that after displaying two records from the subreport(which
could be one to ten), it then displays the sub-subreport records(which is
always one) and then the rest of the subreport records. I have reviewed the
Master Detail Detail tutorial, but I still can't seem to get it right.
subreport Properties:
BottomOffset=0
ExpandAll=False
KeepTogether=True
NewPrintJob=
CreateNode=True
OverFlowOffset=0
ParentPrinterSetup=True
ParentWidth=True
PrintBehavior=pbChild
ResetPageNo=True
TraverseAllData=False
sub-subreport Properties:
BottomOffset=0
ExpandAll=False
KeepTogether=True
NewPrintJob=
CreateNode=True
OverFlowOffset=0
ParentPrinterSetup=True
ParentWidth=True
PrintBehavior=pbChild
ResetPageNo=True
TraverseAllData=False
This discussion has been closed.
Comments
As a test to see if your data is connected correctly, try placing a DBGrid
on your form for each table/query you have (i.e. one for the master, and
one for each detail) and hook them to each datasource. The two detail
tables should move automatically as you traverse through the master table
records. You might also want to try linking your data using parameters or
standard Delphi Table links rather than using the DataPipeline linking.
Finally, be sure that all your subreports are connected to the correct
datapipeline. You can check each one by clicking on the Report | Data menu
option in the Report Designer. If this still does not help, please send a
smaller working example of the issue to support@digital-metaphors.com and
we'll take a look.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com