OK, let's get technical.
Here's the table structure
"ID" int 4, key
"DateRecorded" DateTime
"Location" VarChar 64
The report is counting "hits per day" regardless of location.
Here's some possible data
7683 12/10/2003 4:10:20 Kitchen
7684 12/10/2003 7:55:12 Laundry Room
7685 12/10/2003 14:34:02 Patio
7686 12/11/2003 5:02:56 Kitchen
7687 12/13/2003 9:00:49 Patio
7688 12/14/2003 12:30:00 Back Door
Notice there's no data collected for 12/12/2003. How does 0-data go in?
How will the report be smart enough to make it a 0 for 12/12? If I enter a
row like "7689 12/12/2003 00:00:01 0", it's going to report a "hit" (1) for
the 12th when there shouldn't be anything. It's the Crystal Report that is
grouping by day a count, not any t-sql.
There must be a setting in CR, that tells it to "pad" days with 0 counts.