At 02:08 PM 12/10/2010, Ted Lienhard wrote:
I have a report with three sub-reports. The last sub-report has two breakpoints. One is a Y/N field that sorts alphabetically by the break, as I expected. The second break is on a firstname field-that one does not sort at all. I must be missing something, any ideas anyone?
Ted, Technically, the ORDER BY clause (in Forms/Reports) or defining Breaks (in Reports) are primarily adherent to the Primary/Master table. However ... If you have a form with slave tables and a report with sub-reports, and if you wish to sort the matching rows related to slave table(s) /sub-report(s), you'll need to use the ARRANGE BY clause to achieve your goal. ARRANGE tablename BY columnlist sorts the rows displayed by a form's or report's lower-level tables. Each lower-level table in the form or report that you want to sort requires its own ARRANGE clause. You can specify up to twenty-five tables to ARRANGE and up to five columns in each table on which R:BASE will sort. -- Example 01 (Forms with Slave Tables) Database: RRBYW17 Sample Form: SalesTransactions Associated Tables (5): . Customer (Master) . InvoiceHeader (Slave 1) . InvoiceDetail (Slave 2) . Employee (Slave 3) . Contact (Slave 4) Command: -- Begin EDIT USING SalesTransactions + ARRANGE InvoiceHeader BY TransID, + ARRANGE InvoiceDetail BY ItemNum, + ARRANGE Employee BY EmpLName,EmpFName + ARRANGE Contact BY ContLName,ContFName + WHERE CustState = 'CA' ORDER BY Company RETURN -- End Example 02: (Reports and Sub-Reports) Database: RRBYW17 Sample Report with Sub-Report: CustomerContacts Associated Tables (2): . Customer (Master) . Contact (Slave 1) Command: -- Begin PRINT CustomerContacts + ARRANGE Contact BY ContLName,ContFName + ORDER BY Company WHERE CustState = 'CA' + OPTION SCREEN|WINDOW_STATE MAXIMIZED + |ZOOM_TYPE PERCENTAGE|ZOOMPERCENT 90 RETURN -- End Very Best R:egards, Razzak.
