Subreport Detail Line at bottom of one page reprints at the top of the next page-Help
I have a report that uses a Master-Detail relationship.
The top half of the page is the Workorder information (Master) then the
bottom of the page it starts to print the line items being used on that Work
order.
If the Work Order has enough line items that it needs to continue on a
second page it will print the last line item at the bottom of the first page
as the first item on page 2.
This causes confusion because we end up pulling more inventory than is
needed for an order.
Is there a specific setting at the SubReport level i should be setting that
i'm not?
1.) Should the SubReport.KeepTogether property be TRUE or FALSE
2.) Should SubReport.TraverseAllData property be TRUE or FALSE
I have tried different combinations but can't figure out why it prints the
last line item as the first line item on page 2. I would expect it to simply
continue printing the next line item.
The top half of the page is the Workorder information (Master) then the
bottom of the page it starts to print the line items being used on that Work
order.
If the Work Order has enough line items that it needs to continue on a
second page it will print the last line item at the bottom of the first page
as the first item on page 2.
This causes confusion because we end up pulling more inventory than is
needed for an order.
Is there a specific setting at the SubReport level i should be setting that
i'm not?
1.) Should the SubReport.KeepTogether property be TRUE or FALSE
2.) Should SubReport.TraverseAllData property be TRUE or FALSE
I have tried different combinations but can't figure out why it prints the
last line item as the first line item on page 2. I would expect it to simply
continue printing the next line item.
This discussion has been closed.
Comments
The Details part of my report is a SubReport and the 'Details' section of
the SubReport is inside a Region.
So the last line item on page 1 inside the Region is printing again as the
first line item of page 2. I am absolutely stumped. I have the
Region.KeepTogether property set to TRUE also.
On the Detail Band where the Region exists i have the
DetailBand.BandsPerRecord set to 1 and the PrintHeight is phDynamic.
If i set the Report.DeviceType to 'Screen' so i can preview the report
here's what happens.
1.) I run the report and it Previews a 2 page report. When i look at the
last line item on page 1 everything looks ok. If i click to view Page 2 of
the report it looks correct. However if i then click back to view page 1
again i find that an item has been added to the bottom of page 1 which is
the same item that starts on page 2.
Which version of ReportBuilder and Delphi are you using? Also which DB
and connectivity are you currently using?
As a test, if you remove the region, do you still get the same behavior?
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I am using Advantage Database 12 and their native VCL tools.
The original report was having problems with the duplicate line so i
searched this newsgroup and added the Region to the detail band of the
subreport hoping it would solve the problem. I get the same behavior
regardless if all of my line item components are within a Region or not.
ReportBuilder 10.02 was released over 11 years ago and is extremely out
of date. I suggest downloading a trial copy of the latest version of
ReportBuilder (RB 18.01 for D7) and testing your report with that.
Be sure you have the previous version's install executable available as
installing the trial will uninstall that version.
http://www.digital-metaphors.com/download/
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
installs fine but when Delphi 7 launches i get this error:
"Can't load package C:\Program Files
(x86)\Borland\Delphi7\RBuilder\Lib\dclRB187.bpl. A class named
TraTObjectRTTI already exists.
Do you want to attemp to load this packge the next time a project is
loaded?"
status of my issue if this updated version fixes the problem.