Printing the same record many times

rbuser

My report is printing the same record many many times before going to the
next record in the detail band.

I have a report, an end-user designer,Memory table,qry, data pipeline, and a
datasource on a data module. I link the qry to the datasource. And the
pipeline is linked to the datasource. When you view the report on the
screen or sending it straight to the printer, it prints one record many
times. The detail band should be printed once for each record.

This report only has a detail band. All the marigins are set to 0.05.
Height - 2, Width - 3.25

Why is it printing so many times? Can you help me?

i am using Report builder Enterprise Edition version 9.01, Dbsiam 4.18, and
delphi 6

nicocizik

Hi Semone,

Is it printed each record the same number of times? If so, you need to be
sure the DetailPipeline.BandsPerRecord property is set to 1. Other than
that, there should be no reason this is happening unless somehow your data
is being altered before RB can access it. As always, I recommend upgrading
to the latest version of RB (9.02) which would be a free upgrade in your
case.

--
Regards,

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

rbuser

Thanks, and the bandsperrecord property is set to 1. It is also doing this
when there is one record. It is very weird. I have checked my data output
and it is not creating that many records.

nicocizik

Hi Semone,

As a test, comment out all your event code and re-run your report. If this
fixes the error, periodically begin adding the event code back to isolate
the problem. ReportBuilder simply traverses your data and prints the it top
to bottom when connected to a certain dataset. We have had no issues like
this one with regards to data traversal in the past.

--
Regards,

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