Ensure that the query and report are using the same gift types. The query's summary information does not include all gift types by default. For more information on the summary information filter, refer to What are the default gift types and how to include other gift types when querying on summary information in The Raiser's Edge 7.