• Replies 9 replies
  • Subscribers 414 subscribers
  • Views 107 views
  • Users 0 members are here
Related

Last Gift

Melanye Taylor
$organization

Hello everyone,

 

I’m in the process of creating a report that includes everything except a constituent’s blood type L.  One of the components of one of the lists includes a constituent’s last gift.  Is there a way I can really get only the last gift.  This list gives me all gifts and I must sort by date, then delete all but the last gift.  In normal circumstances, this would not be a problem, but I’m creating 60 lists for 6 reports.  HELP!!!

 

MC35LV

Melanye V. Taylor

Development Operations Database Coordinator

Performing Arts Center of Los Angeles County

135 North Grand Avenue

Los Angeles, CA. 90012

213.972.3123

mtaylor@MusicCenter.org

www.MusicCenter.org

 


This email is solely for the intended addressee, and may contain privileged or confidential information. If you are not the intended recipient, please do not use or distribute this material. If you have received this communication in error, please notify me immediately, return this transmission, and delete or destroy any copies.
Parents
  • $organization

    Rosemary - have you looked at the Output Set Cookbook?

    http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Ticketing/Intro%20to%20Output%20Set%20Builder%20for%20v11%20T-Cast.aspx

     

    I think what you are looking for might be in there – or at least something that you can use as a starting point. Remember to try these out in Test before you use them in Live!

     

    Cheers

    Sandra

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Rosemary Miller
    Sent: Wednesday, July 6, 2016 6:27 AM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: Re: [Tessitura Development Forum] Last Gift

     

    Hi Dale, I know I'm bringing up an old thread, but hoping you might still be able to help. I have an Output Set that includes "Contribution Last Cont Date" and "Contribution Recd @ Last Cont." Are these different than the ones you have listed? These do not seem to be including soft credits, which would be incredibly helpful. Thank you, Rosemary rosemarymiller@theparamount.net

    From: Dale Aucoin <bounce-daleaucoin4707@tessituranetwork.com>
    Sent: 11/30/2011 11:35:40 AM

    Melanye,

    I set up  "last gift date" and "last gift amount" elements in output set builder.  Ours pull data from a local view that includes soft credits but if you don't have one of those you could still just pull from t_contribution - it just won't show soft credits.

    Its pretty easy to set up and I would be glad to share my setup, you would just have to modify it slightly.

    You would need access to the tr_query_element system table.

    Dale




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

Reply
  • $organization

    Rosemary - have you looked at the Output Set Cookbook?

    http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Ticketing/Intro%20to%20Output%20Set%20Builder%20for%20v11%20T-Cast.aspx

     

    I think what you are looking for might be in there – or at least something that you can use as a starting point. Remember to try these out in Test before you use them in Live!

     

    Cheers

    Sandra

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Rosemary Miller
    Sent: Wednesday, July 6, 2016 6:27 AM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: Re: [Tessitura Development Forum] Last Gift

     

    Hi Dale, I know I'm bringing up an old thread, but hoping you might still be able to help. I have an Output Set that includes "Contribution Last Cont Date" and "Contribution Recd @ Last Cont." Are these different than the ones you have listed? These do not seem to be including soft credits, which would be incredibly helpful. Thank you, Rosemary rosemarymiller@theparamount.net

    From: Dale Aucoin <bounce-daleaucoin4707@tessituranetwork.com>
    Sent: 11/30/2011 11:35:40 AM

    Melanye,

    I set up  "last gift date" and "last gift amount" elements in output set builder.  Ours pull data from a local view that includes soft credits but if you don't have one of those you could still just pull from t_contribution - it just won't show soft credits.

    Its pretty easy to set up and I would be glad to share my setup, you would just have to modify it slightly.

    You would need access to the tr_query_element system table.

    Dale




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!

Children
No Data