The code below works fine. The only thing I can think of why mine does not work is there is no relationship between the master and slave tables??
Dan Goldberg -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, March 24, 2009 10:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: arrange by in sub reports At 12:59 PM 3/24/2009, Dan Goldberg wrote: >I have a report based on a dummy table and six non-related temporary >tables. All the columns are different name to avoid relationships. > >The report works well except I am having problems with the arrange by. > >print reportname arrange table2 by column1 asc, column2 asc arrange >table3 by column1 asc, column2 asc > >It does not arrange by. I have tried just one but it still didn't work. >Any ideas on how to sort them?? Dan, Without knowing all details, what results do you get when using the following very simple test: 01. Start RBG76 or Turbo V-8 and CONNECT to RRBYW14 or RRBYW15 02. Start RBEdit and then copy and paste the following code: -- Start 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 While in R:BASE Editor, use [Ctrl + F9] to test the code without saving the file. Let me know what you find. Very Best R:egards, Razzak.

