I've got a weird issue I'm trying to track down. I've got a report that is "missing" rows. It's got several date parameters that get assigned to a sql "WHERE datefield BETWEEN dateparam1 AND dateparam2" clause. The issue is that when the report is run with a large date range, the result set is smaller than it should be. As an example, I ran the dbr report and got 30 rows, then copied the exact sproc statement from the statistics table and ran it in Sql Server Management Studio (SSMS) and it returned 33 rows (which is correct). This report has other parameters besides the date ones, but this issue seems related to the dates somehow. Any known issues regarding this? Or suggestions for further investigation?
Thanks,
-nth-
Forgot to mention I'm running myDBR 3.4.0 (build 1415)