SubReport Sorting Problem

  • Thread starter Thread starter Sharkbyte
  • Start date Start date
S

Sharkbyte

I have an invoice report that generates the individual headers, with a
subreport listing all of the detail charges. The report generates correctly;
however, the detail (subreport) data does not sort correctly. Yet, if I open
the subreport, or the query it is based on, the data is sorted correctly.

I am at a complete loss. I cannot see a reason why the data is being
collected, and processed, sorted but then prints in an apparent random order.

Any suggestions?
 
Reports in Access ignore sorts in queries that feed them. Open the report
that is your subreport in design view and then click on VIEW - Sorting and
Grouping. Select the field you want it to sort on.
 
Forgive me for not being more clear... The Sorting / Grouping is set, with
the field listed first.
 
The sorting and grouping for the subreport must be defined in the subreport,
not in the main report.
Or is it that the details are not following the order of the invoices?
 
The details are printing under the correct invoice, and the Sorting and
Grouping is defined within the sub report...
 
Back
Top