Thanks Razzak and Bill This office is a pain and I was only wanting to send a small command file.
They are still in 6x and the more time I spend doing things like this the less time I have to spend on updating the app to 7.5 Thanks again Marc ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, November 02, 2005 4:30 PM Subject: [RBG7-L] - Re: Order by > At 05:08 PM 11/2/2005, Marc Shluter wrote: > > >I was hoping there was some trick to save time. > > Marc, > > In addition to Bill Downall's wonderful solution, you may define > a variable in report, such as DayOfMonth = (IDay(B_Date)), and > then define a "Break" based on that "variable" to sort the report > in ascending order. Make sure that the variable is evaluated at > the [D]etail band. > > Take a look at the "CustYellowPages" which demonstrates the use > of report breaks using the "variable", defined as expression, in > report. > > Database: RRBYW10 > Report: CustYellowPages > Associated Table: Customer > Expression: vFirstLetter = ('-'&(SGET(Company,1,1))&'-') > Report Break 0: vFirstLetter > Break On: Variable > > Enjoy! > > Very Best R:egards, > > Razzak. > >
