Newbie: Report only displays one record
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
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
This discussion has been closed.
Comments
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com