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

Newbie: Report only displays one record

edited June 2004 in General
Hi all! I am new to Report Builder, and am trying to create a report
for a Delphi 7 application, but for some reason, my report only displays
the first record of my Query.
Here is the scenario: I created a small HR application using Delphi 7
where I can enter employees information for a specific company. My
application is NOT limited to only one company. Now I want to generate
reports with this information. My first report is a complete of
employees for a specific company. Therefore I have created a Form
called RptLstEmpl which has a ppDBPipeLine, a ppReport, a DataSource and
an IBQuery. The form also has a ComboBox which contains the list of
companies entered in the DB and a Preview button. When I run the
application and select to display the list of employees report, I can
then select from which company to display the employees. When I hit the
Preview button, my report is generated, but only the first employee of
my Query is displayed. Why?
Also, what is the best way to proceed when a report should display
information from more than one table?

I hope somebody can understand what I mean ... any help would be greatly
appreciated.
Thanks in advance,
BMac

Comments

  • edited June 2004
    Hi BMac,

    ReportBuilder will only traverse the data it is connected to using a
    DataPipeline. Be sure your report is connected to the correct datapipeline
    by either setting the Report.DataPipeline property or selecting it from the
    Report | Data... menu option in the designer.

    Also, remember that data aware components will only display all their
    traversed values if they are located inside the DetailBand of a Report or
    SubReport.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.