Subreport not displaying correct detail
Hi all,
This maybe a newiequestion, but I am trying to wrte a simple report with
drilldown. I have defined the datasets and the report woks fine otherwise.
Hoever, the subreport does not display the correct data and more to the
point it displays the same data for each parent record.
I have tried to us the drilldown feature but cannot get it to work.
I am using the report builder outside of Delphi (we actually use C++
Builder), although there is a Delphi application that calls the Report
Builder.
I would appreciate your help!
Thanks,
Phil
This maybe a newiequestion, but I am trying to wrte a simple report with
drilldown. I have defined the datasets and the report woks fine otherwise.
Hoever, the subreport does not display the correct data and more to the
point it displays the same data for each parent record.
I have tried to us the drilldown feature but cannot get it to work.
I am using the report builder outside of Delphi (we actually use C++
Builder), although there is a Delphi application that calls the Report
Builder.
I would appreciate your help!
Thanks,
Phil
This discussion has been closed.
Comments
Usually when the subreport displays the same data over and over, the master
and detail datasets are not properly linked. Be sure that the detail
dataset (dataset connected to the subreport) is actually linked to the
master dataset and that the detail is sorted on the linking field. Take a
look at demo 152 located in the \Demos\1. Reports\... directory for an
example of how this should be done and take a look at the following article
on data traversal.
http://www.digital-metaphors.com/rbWiki/Data_Access/Fundamentals/Data_Traversal
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com