In This Article:

In This Article:

Built-in CRM reports like the Donor Detail and LYBUNT/SYBUNT reports are great tools that contain predefined settings and data points for your constituent and donation reporting. However, sometimes you'd like to get more information than what is available in the report or further filter on information that's not currently available. You can leverage the Advanced Query Wizard to further enhance these report capabilities.

In the Donor Detail report, there is a setting to Save Results for Advanced Queries. If this box is checked and the Donor Detail report is run, the results are stored in a temporary table in the database. This makes those data fields available to a constituent-based Advanced Query.

Click the Create New Query button at the top of the Query Wizard window. This opens a new browser tab for your new query.

From the Query Type frame to the left of the window, choose Constituent.

Select the appropriate Purpose of this Query, depending on what you want to do.

Click Next.

Among other output fields you may include in your query, those in the Last Donor Detail Report table are specifically from that table of data from the last time the Donor Detail Report was run. Those can be used in your output fields or filters.

NOTE: Be careful using the Criteria field in your output fields, as it contains all the filter settings from the last Donor Detail Report. If you include it in your output fields, the data returned is a very long string: