Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Lines repeated on top of next page

edited March 2002 in General
I have a report when quite often, but not always, the last few (4 to
6) detail records are repeated at the top of the next page. Totals
are correctly add the records only once. This report does not have
any subreports.

In a related problem, when using a drill-down child subreport set to
Child, the detail record that was drilled will be repeated after the
subreport when the subreport overflows to the next page. This is a
multi-level drill-down with three levels of child reports.

I am using both MS SQL Server 2000 and Paradox database via BDE. (My
application dynamically switches based on the presence of the SQL
Server to support non-networked users.)

This is a rather complex application. I make many dynamic changes to
the report at runtime, but the shell of the report and all the
subreports are present at compile time.

Delphi Enterprise 5.01
RB Ent. 5.56
TExtraDev
DBPiplines via BDE ad ODBC to a Microsoft SQL Server 2000
- or -
DBPiplines via BDE to a Paradox tables

These problems are making me a little nutty. I have tried using the
latest RB demo version and this is still a problem.

Help and advice would be greatly appreciated.

- Richard Poletti
Columbia Sportswear Company

Comments

  • edited March 2002
    I'm having the same problem. In my case however, it is caused by changing
    paper size upon print. For example, the preview is on Letter size, but upon
    printing, the user switches to Legal in the print dialog. The first page
    prints fine, but the second repeats the last few inches of detail band from
    the first page (and so on).
    I wonder if these problems aren't related ?

    I'm using D6 SP2, RB 6.03, Oracle8i
  • edited March 2002
    I am also dynamically changing the paper size and orientation. But I
    do this before I open the datasets. I always have to set the paper
    name, size and dimension as my app is run in Europe, Asia and the US
    so I have to switch between A4, B5, Letter, Legal, whatever the user
    wants. I move objects around to best fit on the page. My problem may
    be associated with that.

    - Rich
  • edited March 2002
    Are you changing the ppReport.PrinterSettings prior to ppReport.Print ?
    If so, you shouldn't be experiencing this problem. Otherwise, If you're
    setting the paper sizes after the ppReport.Print, then we may be
    experiencing the same problem. I don't do any of that stuff. I have my
    papersize set to Letter and I change it in the print dialog off of the
    preview.

    Digital Metaphors needs to respond.
  • edited March 2002
    We will need an example project that isolates the problem. The example
    project should be pared down to show the behavior with the least amount of
    your code as possible. Our approach to solving these kinds of problems is to
    delete parts of the report until the problem goes away. Then we revert the
    latest change and try to figure out why one setting is causing the problem.

    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited March 2002
    Forgot to mention: Please send an example to support@digital-metaphors.com


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited March 2002
    Hi Jim,

    I've sent off an email with a test app.

    The app simply opens customer.db and has only a detail band.

    The problem can be reproduced in the IDE by Previewing, clicking on the
    print dialog and changing the papersize from Letter to Legal.
    The last 5 lines of the first (legal) page are repeated on the second
    (legal) page.

    I am using an HP5Si printer running Delphi 6 update pack 2 (enterprise) and
    RB 6.03

    Thanks,

    Ben Hoffman
    Programmer / Analyst
    Sirs Publishing, Inc.
    1-800-232-7477, Ext. 797
    benh@sirs.com
  • edited March 2002
    We did not receive anything from you at support@digital-metaphors.com
    Please try sending it again.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited March 2002
    Sorry, I messed up the address. I've resent it.
This discussion has been closed.