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

Inifinity Loop of My report

edited July 2003 in End User
Dear all,

I have a report which is working properly originally. However, one of our
customers find that the report will inifinity loop during preview of the
report in certain record (Not all record will loop). I have worked a lot on
debuging but still cannot find out the problem, should any one can help me?

I have placed a small SQL Server(2000) Database Backup file and a demo
project(Delphi 6) on web, they can simulate the inifinity loop problem.

DB file: http://raymondicy.uhome.net/DB.zip
Project: http://raymondicy.uhome.net/Project.zip

Thanks a lot.

Raymond Ng
----------------------------------------------------------
Programmer
Orbitec Solution Limited
Tel: (852) 25755125
Fax: (852) 25752221
Email: raymond_ng@orbitec-solution.com

Comments

  • edited July 2003
    Ask your user what printer they are using. You may have a static height
    control that isn't fitting on the page. Each printer has a different
    unprintable area. Increase the report's margins to match those found for
    your user's printer specs.Test this by downloading the user's printer driver
    from the manufacturer and installing it. Set this as the default printer for
    the Report.PrinterSetup. This way when you preview to the screen, it will
    actually use the printer driver for this printer to paginate the report.
    Perhaps then you can see the problem with the available space or if you have
    some code that is trying to print a static height contorl on the page when
    it can't fit, so it continues to request pages inifitely.


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.