I have on occasion done special sorts by added a column that I number in
the sort order I want. It can be numbered in reverse order, and then the
report comes out upside down <G> as needed.
Javier Valencia wrote:
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
--- RBASE-L
=======================3D=======================3
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================3
D=
