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

Only first page of data

edited April 2007 in General
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

Comments

  • edited April 2007
    Hi Bob,

    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2007
    Nico,

    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.


  • edited April 2007
    This thread is being handled via email. I will post the solution to the
    issue once it is solved.

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