I created a report on a standard report type to fetch lead data. My filters are Show Me = All Leads, Created Date = Last 30 Days, and Lead Source = Broker. The report returns 40 records, but when I query the records with the same filters, it returns 45. I also created a report on a custom report type, and it returns 45 records.
In my custom report type, I am using only one object, Lead. However, in the standard report type, multiple objects are used: User, Owner, Role, Lead, Account, and Contact. Does this affect the data being fetched?
End User = System Administrator
#Salesforce Developer #Salesforce Admin #Reports & Dashboards
Yes, the Report Type can affect the record count. It’s not simply because the standard report type contains multiple objects; the relationships and “with/without” settings defined in the report type can determine which Lead records are included.
I would compare the standard and custom report types, especially their object relationships, standard filters, and filter logic. Also ensure the report and SOQL are running with the same user/access context.
So, the 40 vs. 45 difference is likely related to the report type’s record scope/relationships, rather than SOQL returning incorrect data.
https://help.salesforce.com/s/articleView?id=analytics.reports_report_type_reference.htm&type=5&utm_sourceHope This Helps!!
