Report Data doing strange things
We have a strange issue going on here. I have a Stored procedure that runs for a report. The top part of the report is a cross tab table. It shows two different suppliers and the number of outsanding items they have
Supplier 1 shows a total of 36
Supplier 2 shows a total of 84
Giving a total of 120.
The totals are just counts of a job identifier.
We have a drill down on this report that shows a little more detail for each item but when we count those Supplier 1 has 38 and supplier 2 has 84 giving us 122.
How can the cross tab have different information when it all comes from the same data?