I have a report that was developed in SSRS 2008. It renders inconsistently.
The report has a pivot on two separate columns. One time I run it, and the output is fine and the report renders with data and all of the data checks out. Inconsistently, when I run the report using the EXACT same parameters, the report renders,but no data is displayed, even though I know that data should be displayed on the report.
I put a trace on the SQL Server, caught the query cut it out and ran it in Management Studio and the SQL Server query runs successfully every time.
Additionally, I enabled the NoRowsMessage table property to say "No records match the parameters you selected." When the report renders as if there was no data returned from the SQL Server, even though I know the SQL Server returned data, I don't see the message. When I choose parameters that I know shouldn't return data I see the message.
There is no error message. There is nothing unusual in the logs that I can see.
This inconsistent behavior happens in Visual Studio.Net 2008 SSRS designer, on the QA Server, on the Production Server, in an ASP.net application, and in a Win Forms application. Everyone who has observed the behavior is baffled.
Does anyone have any idea why I am seeing these intermittent results? I have a call in to the Microsoft SSRS team and they seem stumped.
Thank you in advance.