To run this report:
- Navigate to Revenue
- Under Reports, click Giving Detail
- In the Designation filter, search for your designation here.
- Enter a date range if applicable.
- Click View Report.
Option 2: Build a Revenue Query. If you need additional information about the gifts, you can also create an ad-hoc query.
Start your query:
- Navigate to Analysis, click on Information Library
- Click Add an ad-hoc query
- Select the Source View of Revenue and click OK
- In order to filter on gifts made to a specific designation, expand Application Details in the left column. In the middle column, drag Designation System Record ID to Include Records Where. Set the operator to be Equal to or One of. Search for your designation or designations in this screen and click OK.
- If you'd like to filter by Date, in the left column, highlight Revenue at the top of the column. In the middle column, drag Date into Include Records Where. Set this field to be between or equal to your date range.
- If you'd like to only show certain types of revenue (for example, pledges, not pledge payments, etc.), see our related solution What query filters should I use to find contributed revenue? for suggestions.
- To see the amount of the donation to the specific designation, we recommend using the Application Amount field. This will show you only what was donated to the designation you're filtering on. This is helpful if you have split gifts in your database. To add this field, in the left column, highlight Application Details. Form the middle column, drag Amount to Results Fields to Display.
- If you'd like to see Constituent Name or other constituent Details, highlight Constituent in the left column. Drag Name to Results Fields to Display.
- Click Set save options tab and Name your query
- If you will be using this query elsewhere in Altru, mark to Create a selection
- If you will be using this query in another query, mark to Show this Selection in the Query Designer
- Save and Close