I was afraid of that. I just thought of a solution. I will sort the data when create and load the temp tables before the report generates.
The reason I am doing this is we have a six day shipping calendar which they want in a specific format. Dan Goldberg -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Tuesday, March 24, 2009 11:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: arrange by in sub reports Dan, You have to have at least one common column between each of the slaves and the master. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Tuesday, March 24, 2009 2:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: arrange by in sub reports 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.
