Thank you. Now it works. Patti
________________________________ From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thursday, June 6, 2013 3:39 PM Subject: [RBASE-L] - Re: can't seem to sort a Subreport At 03:08 PM 6/6/2013, Patti Jakusz wrote: >I am having a hard time with sorting data in a subreport. I have a report >that lists clients, then a subreport that lists dates of visits with the >client. I went to Breaks on the subreport and selected my visit date >column and said to sort it, ascending. But it doesn't. They are listed >on the report in the order they appear in my table. Is there something >else I'm supposed to do? > >I'm using 9.5 and Win XP. Use the ARRANGE BY clause to sort sub-report. 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: RRBYW18 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: RRBYW18 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. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
