Steve, The need for a way to indicate DESC as part of the column break definition was a subject of discussion on this list some time ago. I seem to remember that Razzak was in favor but nothing came of it.
As a work around if the column is a numeric data type (integer,real,double,currency) and you use a view to drive the report you could create a special break column by multiplying the value by -1. You could also manipulate a date column by to an integer by creating an integer column (datecol - .#DATE). I haven't found a way to manipulate character data to achiever the above. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Fri, 9/26/08, Wills, Steve <[EMAIL PROTECTED]> wrote: > From: Wills, Steve <[EMAIL PROTECTED]> > Subject: [RBASE-L] - RE: REPORTS, BREAK, DESCENDING ? > To: "RBASE-L Mailing List" <[email protected]> > Date: Friday, September 26, 2008, 1:18 PM > I'm not complaining, mind you, just curious, since the > way I did it, > with the ORDER BY ... DESC, worked just fine. > > > > Of course, if I hadn't checked the sequence of breaks > in the report to > keep the ORDER BY consistent therewith, I'd probably be > asking about > some other "blind-spot" ... say, did anyone ever > think about this one - > it's known as a R:earview MiRR:or. > > > > I know, that's a really bad stR:etch, but it's > FR:iday, R:ight? > > > > L8R:, > > Steve in Memphis > > > > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Javier > Valencia > Sent: Friday, September 26, 2008 12:59pm 12:59 > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: REPORTS, BREAK, DESCENDING ? > > > > Steve, > > > > No, you have not missed. The break in reports simply > indicates how the > report should be segmented and by default, the order is > ascending. The > "ORDER BY" clause can be used to override the > order at run time. I > imagine that the great majority of reports are sorted in > ascending > order, except perhaps when dates or currency are involved > and this is > the reason why "ascending" is the default and you > only have to remember > to use the ORDER BY clause when the opposite sort is > desired. Having > said that, it would be nice to have the option of defining > the default > direction of the sort; although, it most likely has been > incorporated in > R:Base eXtreme...you know, R:azzak's ESP... > > > > Javier, > > > > Javier Valencia > > 913-915-3137 > > > > ________________________________ > > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Wills, > Steve > Sent: Friday, September 26, 2008 11:58 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - REPORTS, BREAK, DESCENDING ? > > > > Am I blind or is it possible to define a Report Break as > DESCending at > Design Time? > > > > I know I can use ORDER BY ... DESC at Run Time, as long as > my ORDER BY > sequence is in accord with the Report Breaks. > > > > However, I feel like this is a feature that might exist, > but I'm the > sort of person who would've missed it. > > > > > > Thanks, > > Steve in Memphis > > > > > > > > J. Stephen Wills > > Program Manager, Research Informatics > > Office of the Vice Chancellor for Research > > University of Tennessee Health Science Center > > 62 S. Dunlap, Suite 400 > > Memphis, TN 38163 > > Office: 901-448-2389 > > FAX : 901-448-7133
