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

Subreport pages out of sequence

edited May 2003 in End User
I have a report with several subreports developed in the end user
environment using Delphi 5 and Rbuilder 6.0. The first page of the report
contains two subreports with the print behavior set to section. The second
of these subreports also contains two child subreports. The database is MS
SQL Server 2000. The main page is just a container for the first two
subreports. There are 5 linked views that provide the data for the various
subreports. There is a sort on two fields of the first of the linked views
and the report provides for selection of certain groups based on a field in
this view. There is also some RAP code in several events. Yes, this one has
a little of everything. Each subreport seems to print in proper sequence
when tested with small groups. However, in production where many pages are
created in preview mode, a large number of pages print at the end. Many of
the pages are blank but some are out of sequence subreport pages. We are
examining the possibility that something about the sort or selection is
causing a problem. Is the volume or the combination of the volume plus the
sort a factor? Taken at face value it would appear that this conclusion is
correct. Any ideas?



G. Mitchell

Comments

  • edited May 2003
    It may be a bug in the SQL generation since you have RB 6.0. Is the SQL we
    generate correct? You can view the SQL we generate for master detail by
    Ctrl-mouse clicking over detail dataviews. This is the magic SQL that should
    reflect the query that returns all the detail records ordered by its
    master's order by's/joins. So, these can get quite complex. The next step is
    to run this report using RB 7.02 as there have been fixes to the linking
    logic since RB 6.


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.