Janet,
<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.>
Are BrandX and Customer_3 the same person???
Provide the print statement your using!
Tell me a little more about your report in this format(explain what you have
in each section)>
RH - Report header (Primary Heading first page)
PH - Page Header (Heading for all pages)
H1 - Break 1 header
H2 - Break 2 header
Detail - Detail Section
F2 - Break 2 footer
F1 - Break 1 footer
PF - Page footer
RF - Report footer
Sounds like your breaks - need more info to assist!
Here is an example that I use to print Invoices for A/R recapping by
customer
RH - No Used
PH - Header for Report title and all column headers
H1 - Customer Number
D - Detail (Invoices outstanding and paid recapped not invoice detail
transactions -
date/invoiceno/tax/shipping/invoicesubtotal/invoiceamount/paymentstatus)
F1 - Customer Name and sum of invoice amounts (totals per customer)
PF - No used
RF - Grand totals for all customers
I set break 1 for customer number to reset the sum vars per customer
print arcrdinq order by custno,invoiceno asc
Gives me a report that is sorted by custno and invoiceno with subtotal for
customer invoice activity and grand totals for all customers
print arcrdinq where custno = '10258' order by invoiceno asc
Gives me a report that is sorted by invoiceno for that customer with
subtotals and grandtotal (which are the same value)!
Best regards,
Oma
