Author Topic: Totals reported in Reports different to those found in Search (Read 340 times)

Loster · May 09, 2014, 08:58:07 am

Hi everyone,

I've seen a previous post on this topic with no replies, so thought I'd try again here.

I have a report of Membership totals pinned to the CRM Home page dashboard. And it's showing different numbers than when searches are run with the same criteria. I've tried refreshing the dashboard, and running these reports themselves, but still the same numbers.

The Report is reporting 9 more Members than when the equivalent search is performed (the criteria is of four membership types).

I imagine this is something to do with the DB query that is performed for a report and a search, like perhaps the report is including some cancelled memberships where the search result won't. Something like that.

If anyone could point me at where to look to find out how each is working, and so hunt down the discrepancy, I'd be grateful.

Carl.

JonGold · May 09, 2014, 10:31:17 am

Hi Carl - that depends, are you a SQL-savvy person? If so, you can log SQL queries, or we can walk you through adding debug statements to see the SQL.

However - you don't necessarily need that! If you can identify what it might be about those contacts that differentiates them - as you said, perhaps they're canceled memberships - then you're most of the way there.

If you're having trouble identifying those 9 contacts, try adding the contacts from the search and report each to their own group, then use the include/exclude custom search to identify the 9 rogue contacts.

CiviCRM Community Forums (archive)

News:

Author Topic: Totals reported in Reports different to those found in Search (Read 340 times)

Loster

Totals reported in Reports different to those found in Search

JonGold

Re: Totals reported in Reports different to those found in Search