Sad Sorting Situations

Is there any quick way to get the output of the User Defined Format from a List report (under Labels and Letters) to sort alphabetically by last name after it's been saved to excel format?  Or am I forced to write a quick report in SSRS that simply incorporates the sort_name field from T_CUSTOMER?

And please don't invoke the dreaded INFOMAKER...(cue Wilhelm scream)

Parents
  • Thank you, this sounds intriguing. Spell away.

     

    Matt Gonzales

    Database Administrator

    Houston Grand Opera

    510 Preston St | Suite 500, 5th Floor

    (v) 713-980-8702 | (f) 713-225-2574

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Lucie Spieler
    Sent: Thursday, September 27, 2012 3:25 PM
    To: Matt Gonzales
    Subject: RE: [Tessitura Next Generation Forum] Sad Sorting Situations

     

    I added the T_CUSTOMER.sort_name column as a query element. You can build a query easily that gives you the fields you need. Let me know if you need more information, and I’ll spell it out.

     

    Lucie

     

    _____________________________
    Lucie Spieler
    IT Development and Training Manager

    Editor, Season Program Book

    FLORIDA GRAND opera




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

Reply
  • Thank you, this sounds intriguing. Spell away.

     

    Matt Gonzales

    Database Administrator

    Houston Grand Opera

    510 Preston St | Suite 500, 5th Floor

    (v) 713-980-8702 | (f) 713-225-2574

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Lucie Spieler
    Sent: Thursday, September 27, 2012 3:25 PM
    To: Matt Gonzales
    Subject: RE: [Tessitura Next Generation Forum] Sad Sorting Situations

     

    I added the T_CUSTOMER.sort_name column as a query element. You can build a query easily that gives you the fields you need. Let me know if you need more information, and I’ll spell it out.

     

    Lucie

     

    _____________________________
    Lucie Spieler
    IT Development and Training Manager

    Editor, Season Program Book

    FLORIDA GRAND opera




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

Children
No Data