Org Giving Totals

This script runs from the OrgSearch BlueToolbar. It shows each organization in the search, with the total Giving for a date range.

The Givers counts will include both husband and wife if they give jointly.

The first comment at the top of the script ensures that this report can only be run by a Finance user. The second comment causes the script to ask for a start and end date. The end date is inclusive for the whole 24 hours of that date.

The recommended name is OrgGivingTotals

Sample Report

Use the following code to Create the SQL Script. See How to create a SQL Script.

;WITH amts AS (
        Total = SUM(c.Amount)
    FROM dbo.Contributions2(@MeetingDate1, @MeetingDate2, 0, 0, 0, 1, NULL) c
    JOIN dbo.CurrOrgMembers(@orgids) om ON om.PeopleId = c.PeopleId
    GROUP BY om.OrganizationId
membercounts AS (
    SELECT m.OrganizationId, Members = COUNT(*)
    FROM dbo.CurrOrgMembers(@orgids) m
    GROUP BY m.OrganizationId
givers AS (
    SELECT m.OrganizationId, Givers = COUNT(*)
    FROM dbo.CurrOrgMembers(@orgids) m
    JOIN dbo.FamilyGiver(@MeetingDate1, @MeetingDate2, NULL) g ON g.PeopleId = m.PeopleId
    WHERE g.FamGive = 1
    GROUP BY m.OrganizationId
FROM dbo.Organizations o
JOIN membercounts mc ON mc.OrganizationId = o.OrganizationId
JOIN givers g ON g.OrganizationId = o.OrganizationId
JOIN amts a ON a.OrganizationId = o.OrganizationId

Latest Update 11/13/2020

Modify image link with secure protocol.