reporttemplate.pngsample1.pngsample2.png
I have a report that lists out performance numbers across what I will call department names. As I add department names to the where clause on this query, I'm finding Crystal to confuse numbers between departments.
I've attached two sample reports. Sample 1 shows the "AO" department name with 840 count which is the correct count as verifed by the SQL query.
Sample 2 shows the AO department name with 0 count. The number of departments included in this report has gone up by one. The department "Admin" which is the added department shows 0 counts through the query but the report now seems to give "AO" numbers to "Admin". AO and Admin both appear on the second page of the report. All other departments are fine.
Im running on Service Pack 32.