I've had a rather curious thing occur today after some security patches were installed over the weekend. Some of our SQL SSRS Reports started only returning one line of data. It has been working for a few months prior and has not changed so that eliminates the report itself having a problem. My next thought is maybe the data didn't come down from our data warehouse due to the updates that were occurring. So I then ran the SQL Profiler to capture the query that the report is generating and I ran the query alone and it then returns all the data expected. This eliminates not having the data. At this point I'm at a little bit of a loss. Has anyone see anything like this before and has any suggestions?
*This post is locked for comments
I have the same question (0)
