• Replies 4 replies
  • Subscribers 414 subscribers
  • Views 180 views
  • Users 0 members are here
Related

Gift Output for End of Year

Seth Ghitelman
$organization

I am looking to generate an output file that will be used to generate a letter for donors listing all the contributions in the previous year. So I need to have multiple gifts on one line of data. I need gift date and gift amount.  Any output chefs have a good recipe?

 

  • $organization

    Seth,

    We have an SSRS report for our Annual Giving Summary which uses the following parameters:

    • Contribution Start Date (required)
    • Contribution End Date (required)
    • Campaigns (required)
    • List (optional) 


    The report output populates a pre-loaded annual giving statement which pulls envelope salutation information and has lines which report gift date, category (fund), gift amount, and fair market value (if applicable). There's also detail which reports the date and amount of a pledge payment's receipt.

    Let me consult with our consortia guru who built the report to see if the code is shared anywhere.

    Thank you,

    Brian

     


    [edited by: Brian Parker at 4:34 PM (GMT -6) on 9 Jan 2017]
  • $organization

    Thanks, Brian.

     

    That would be great.

     

    Seth R. Ghitelman

    Tessitura Systems Administrator

    __________________________________

    George Washington’s Mount Vernon

    P.O. Box 110, Mount Vernon, Virginia 22121

    O: 703.799.6846 | F: 703.799.8645
    sghitelman@mountvernon.org

    mountvernon.org | @mountvernon

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Brian Parker
    Sent: Monday, January 09, 2017 4:42 PM
    To: Ghitelman, Seth <SGhitelman@mountvernon.org>
    Subject: Re: [Tessitura Development Forum] Gift Output for End of Year

     

    Seth,

    We have an SSRS report for our Annual Giving Summary which uses the following parameters:

     

    • Contribution Start Date (required)
    • Contribution End Date (required)
    • Campaigns (required)
    • List (optional)

    The report output populates a pre-loaded annual giving statement which pulls envelope salutation information and has lines which report gift date, category (fund), gift amount, and fair market value (if applicable). There's also detail which reports the date and amount of a pledge payment's receipt.

    Let me consult with our consortia guru who built the report to see if the code is shared anywhere.

    Thank you,

    Brian

     

    From: Seth Ghitelman <bounce-sethghitelman9456@tessituranetwork.com>
    Sent: 1/9/2017 4:19:31 PM

    I am looking to generate an output file that will be used to generate a letter for donors listing all the contributions in the previous year. So I need to have multiple gifts on one line of data. I need gift date and gift amount.  Any output chefs have a good recipe?

     




    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!

  • $organization in reply to Seth Ghitelman

    Seth,

    Check your email for the files in just a few minutes.

    Thank you,

    Brian

  • $organization

    Do you have this report still available? I'd love to use it too. 

    Thanks!

    Brighton