I’m using a pivot table from the report generator. I am using a filter on my SQL (where clause) to limit the number of rows being selected, but my pivot table does not show the same count as an SQL count(*).
Here’s my target count:
select count(*) from countpivotmv where purchdate >= '01/01/2019' and maildate >= '01/01/0001'; count ------- 55402 (1 row)
Here’s what I get from the pivot table:
Here’s the report data band:
As you can see, it is a straight select of the same table as my select above and the filter data is the same.
Yet my resulting count is NOT the same.
What am I doing wrong?
Would it work better if I turned this into XML and a screen rather than using the Report Generator?