lifetime transaction amount/number field in report writer interactions report

Options

Hey folks!

Does anyone know of a field available in Report Writer: Interaction Detail Report that would tell the reader whether or not the constituent for whom the interaction is logged has ever made an online/offline donation transaction?

I wouldn't necessarily need the number of transactions or the total lifetime amount of online transactions.  I would use a null value in the field to assume that the constituent was not an online donor while a non-null value would indicate that the constituent was an online donor (or had a credit card transaction posted to her record offline by my staff).

Any suggestions?

Many thanks in advance!

Tagged:

Comments

  • Hi Virginia, there should be a field called Donor Status - I know for sure that is available in Query.  Are you wanting to filter by this value, or just have it appear as a column in your report?

Categories