Home General

Subreport Detail Line at bottom of one page reprints at the top of the next page-Help

edited April 2017 in General
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.

Comments

  • edited April 2017
    Adding More Information:

    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.
  • edited April 2017
    More Info:

    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.





  • edited April 2017
    Hi Michael,

    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?

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2017
    I am using Delphi 7 Enterprise and Report Builder Enterprise Edition 10.02.

    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.


  • edited April 2017
    Hi Michael,

    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/

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2017
    I uninstalled ReportBuilder 10.02 and tried to install RB 18.01. It
    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?"




  • edited April 2017
    Nevermind. I figured out the installation problem. I will report back on the
    status of my issue if this updated version fixes the problem.

This discussion has been closed.