Be sure to include the higher level report break points in the sorting order
PRIOR to the invoice number field, e.g., "ORDER BY CUSTOMER, etc." It's not
clear to me by what you mean by sorting by "invoice totals", but if you
already have an invoice number breakpoint in your report then "ORDER BY
CUSTOMER, INVOICE_NO" should work.
Pat
> Rbase 2000 6.5 for windows - build 1.839 x RT03
>
> In the report 'where builder' the user is trying to get the invoices to
sort ascending by invoice number. The break points are by customer and then
by invoice totals. When the option to sort ascending is put in the equation,
the data prints out ONE invoice number per page.
> What are we missing in the equation? Do we need to redefine the
breakpoints?
>
> For instance:
> We tell it to print only the invoices from "BrandX" Company.
> Then, print ALL of the invoices for "Customer_3" AND sort these ascending.
> Rbase prints Customer_3 invoices, ONE PER PAGE.
>
> tia
> Janet
>
