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.
--
KARL DEWEY
Build a little - Test a little


"Sharkbyte" wrote:

> 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?

Forgive me for not being more clear... The Sorting / Grouping is set, with
the field listed first.



"KARL DEWEY" wrote:

> 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.
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "Sharkbyte" wrote:
>
> > 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?

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?
--
KARL DEWEY
Build a little - Test a little


"Sharkbyte" wrote:

> Forgive me for not being more clear... The Sorting / Grouping is set, with
> the field listed first.
>
>
>
> "KARL DEWEY" wrote:
>
> > 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.
> > --
> > KARL DEWEY
> > Build a little - Test a little
> >
> >
> > "Sharkbyte" wrote:
> >
> > > 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?

The details are printing under the correct invoice, and the Sorting and
Grouping is defined within the sub report...


"KARL DEWEY" wrote:

> 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?
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "Sharkbyte" wrote:
>
> > Forgive me for not being more clear... The Sorting / Grouping is set, with
> > the field listed first.
> >
> >
> >
> > "KARL DEWEY" wrote:
> >
> > > 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.
> > > --
> > > KARL DEWEY
> > > Build a little - Test a little
> > >
> > >
> > > "Sharkbyte" wrote:
> > >
> > > > 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?