Hi,
I have a report where I'm trying to sort by last name then first name. I cannot get the Order By command to work. Can someone share with me what I might be doing wrong? Syntax Below:
ORDER BY d.lname, d.fname DESC
I’ve entered just that and it is as if my report is not recognizing it. The names still appear ordered by account number.
Triland L. McConico
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers Sent: Friday, October 26, 2012 1:48 PM To: Triland McConico Subject: RE: [Tessitura Technical Forum] Order By Command Not Working
Triland,
What is your desired result, and what are you getting that isn't working?
The line:
should order the results by lname _ascending_, followed by fname descending:
Adams John
Adams Abigail
Brown Sally
Brown Charlie
For ORDER BY "ascending " (asc) is implied, "descending" is must be specified, and you specify it column by column.
--Gawain
From: Triland McConico <bounce-trilandmcconico7946@tessituranetwork.com> Sent: 10/26/2012 2:07:54 PM
I tried and it still does not work. Anything else I might try. Where you able to get it to work on your side.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jason Kaiser Sent: Friday, October 26, 2012 12:52 PM To: Triland McConico Subject: Re: [Tessitura Technical Forum] Order By Command Not Working
Try: ORDER BY d.lname, d.fname
From: Triland McConico <bounce-trilandmcconico7946@tessituranetwork.com> Sent: 10/25/2012 6:54:00 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!