Repeating records on simple report

rbuser

Hi all. I am a fairly new user of Reportbuilder. I am trying to create a
simple report based on 1 dbisam table. I just have Header, Group, Detail,
Group Footer and Footer bands on the report. I have one dbpipline linked to
the table I'm reporting from. There is no event code for the report. I'm
only using a group in order to get each record to print on a separate page.
The group is based on the unique primary key of the table...ID.

It prints the first record on page 1. It prints the second record on page 2.
Then it continues to print the second record forever on all subsequent pages
until I click cancel. There are only 3 records in the table. It never goes
to the third and final record.

When I delete a record from the table leaving only 2 records, it prints
correctly a 2 page reports and stops. When I add the third record it does as
described above. I have tried all the settings I can think of to no avail.

I am using Delphi 7 and dbisam 4.21 build 10 and reportbuilder 9.02.

Does anyone have any suggestions? Thanks in advance for any help anyone can
give me.

rbuser

Also, if I get rid of the group so that records print with no page breaks,
it prints
record 1
record 2
record 3
record 2
record 3
Then stops

nicocizik

Hi Deborah,

ReportBuilder traverses your data as-is. If you connect your table to a
DBGrid on your Delphi form do you just get the three records you expect?
Instead of using a group to separate the pages, you could place a
TppPageBreak object inside the detail band of your report. The pagebreak
component is located in the Advanced Components toolbar.

If this does not help please send an example of your report in .zip format
to support@digital-metaphors.com and I'll take a look at it for you.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico. Thanks for your reply.

The table is connected to an expressquantumgrid components and the 3 records
display fine in the grid.

I took out the group break and now its just a few fields printing from each
record in the detail band. If I don't use many fields and the 3 records fit
on 1 page then it prints them fine and stops. If I add a few more fields to
the detail band so that all 3 records can no longer fit on 1 page and must
continue on the next page then it prints

On first page:
record 1
record 2
first half of record 3

On second page:
second half of record 3
recond 2
record 3

If I put the grouping in OR if I use a page break, then it prints the first
record on the first page and the second record on all subsequent pages
forever.

It seems that anything that makes this report take more then 1 page to print
screws it up in one way or another. I have other reports set up that work
just fine. I've compared the settings in this report with the others and
just don't see any differences. I've also checked the demos and again, don't
see any problems.

Hope I explained this well enough. Thanks for your help.

Deborah

nicocizik

Hi Deborah,

Is there any event code associated with this report? If you recreate the
report from scratch do you see the same behavior? What type of fields are
you placing inside the detail band? Any subreports?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com