Receipt amount for gifts

Options
I need to create a report that contains the receipt amount for specific events.  However, the issue is that when you use the Gift Detail and Summary Report and add that column, it does not total the column.  Is there a work around?  We currently have more than 30 events and it will be rather cumbersome to create excel spreadsheets for each one to capture this.


Thank you very much for your input.

ML Marley

Comments

  • Ouch, you're right!  


    For any report where I need totals on a regular basis I usually create a pivot report off a gift query.  It's not as pretty as a report, but it is useful in some cases.
  • Are you familiar with setting up Custom Reports using Crystal Reports? This seems like a pretty easy one to set up that you could use for each event.  (I am working on a similar project now for our organization.)
  • ML Marley:

    I need to create a report that contains the receipt amount for specific events.  However, the issue is that when you use the Gift Detail and Summary Report and add that column, it does not total the column.  Is there a work around?  We currently have more than 30 events and it will be rather cumbersome to create excel spreadsheets for each one to capture this.


    Thank you very much for your input.

    ML Marley

    I agree with Rebecca, a Crystal Report would be an elegant and reusable solution. Outside of that, if you don't have any split gifts, you could use a gift query (not as pretty data). Cheers!

Categories