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
