report, subreport sort issue

[Dave]

I am having a problem with the sorting on a report that
contains a synchronized sub report.

The sub report query is syncrhonized with the main report
query on two fields and everything looks good as far as
the data linking correctly.

However, when I run the report, the records from the main
query are not sorting based on the order by fields
specified in the main query. If I just run the query
directly, the records are sorted correctly. When I run
the report which is based on the exact query, I get
different results. The main report query is sorted on 3
fields (a,b,c). The sub report query does not have an
order by on it. It is the first sort field that does not
seem to be getting applied correctly. Any ideas???

Another issue is that every time the synchronized link
fields change a new page is generated. I actually want a
break to occur when another field changes (i.e. not the
synchronized fields) on the report. I have looked at all
the page headers and footers and the page breaks are set
to none. I cannot figure out how to change this page
break processing that seems to the default for the linked
fields.

Thanks for any help,

Dave

 

[Jeff Boyce]

Dave

Sorts you do in queries don't affect order in reports. Seems like they
should, but they don't. You'll need to set up Sorting and Grouping in your
report definition.