This is a problem that I thought was a Reporting Services issue but now realize is something different, possibly in a SQL Server driver.
We have some reports where we compute report totals for head count and various compliance percentages in the stored procedure. There have been intermittent problems where the head count incorrectly displays as 0 on the SSRS report. The stored procedures, executed in SQL Query Analyzer, always return the correct value. SSRS problem, right?
Well...I was recently directed to begin porting our reports to a new web site using CakePHP. As an interim reporting solution we're using the existing stored procedures (the new website will have a new database but for some period of time the old & new databases will be synced). I'm finding that the same reports rendered to the browser using PHP intermittently display 0 for the head count on these same reports!
Has anyone else ever run into this?