Only first page of data
Hello All,
While not new to banded report writers I am new to Report Builder. I've
taken over development on some established systems that make extensive use
of Report Builder and am doing pretty well with fixing minor issues but have
come down to one issue that I can not seem to figure out. I have a report
that is a master/detail (parent/child?). The query the report is based on
returns over 100 rows but my report only display one page, about 25 detail
lines. The report is grouped by the master record's ID column.
The data that appears is correct there just is not enough data being
reported. Any and all suggestions are appreciated.
Thanks
While not new to banded report writers I am new to Report Builder. I've
taken over development on some established systems that make extensive use
of Report Builder and am doing pretty well with fixing minor issues but have
come down to one issue that I can not seem to figure out. I have a report
that is a master/detail (parent/child?). The query the report is based on
returns over 100 rows but my report only display one page, about 25 detail
lines. The report is grouped by the master record's ID column.
The data that appears is correct there just is not enough data being
reported. Any and all suggestions are appreciated.
Thanks
This discussion has been closed.
Comments
A master detail report uses two datasets, a master dataset containing unique
master records, and a detail dataset containing detail information about
each master (perhaps numerous times). Is this the format your data is
arranged?
What database and connectivity are you using? How is your data defined?
Are your datasets in Delphi on the application form or in the Data tab of
the report designer (DADE)? Does the report perhaps contain a search
condition (Autosearch)? When you preview the report, is there a magnifying
glass button on the top toolbar?
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Thank you for the quick reply. My report really isn't a master/detail
because I'm using a multiple table query to return only a single result set.
The master record information is repeated in each row and the report uses a
group band based on a change in the master record id. The first page shows
two group bands followed by the detail's record fields on the reports detail
band.
I'm using the TADODataset/TDataSource/TppDBPipeline to handle the query and
access the fields on the report. I'm not using the DADE feature. And there
is no magnifying glass on the tool bar. On my original post my
TppDBPipeline were TPPBDEPipeline but I have changed them to the DBPipeline
and I still get the same results.
Thank you again.
issue once it is solved.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com