Subreport pages out of sequence

rbuser

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

digitalmetaphors

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