I was facing a weird issue on SSRS (SQL Server Reporting Services) wherein each page of my report was setup to show Header Row, but was actually not.
I had an SSRS table (Tablix) which was setup to repeat header rows on each page of my SSRS report. This option must be setup as shown below:
Despite setting up as shown above, it was not repeating the header row on all pages, except the first one.
Upon digging more on this, I got to visit a blog named Business Intelligence Chronicles by Christo Olivier. The post which saved (taught) me on how to overcome this issue is: Header Row Does Not Repeat On Subsequent Pages.
It’s very informative and crystal clear in terms of how it explained the steps to follow.
This is a very painful issue that took my entire time and effort in solving it.
I am not sure how many of you know that SQL Server 2012 Reporting Services doesn’t support Safari and Chrome browsers (in fact, it’s only partially supported). But it’s high time, you know it. There is a browser support page on Microsoft website, that can be seen here: Planning for Browser Support.
I recently upgraded our SQL Server to 2012 and all my SSRS reports were working till last week. All of a sudden, my reports started showing up nothing other than the report header and parameters section on Google Chrome and Apple Safari browsers. Since the management team is fully on Apple technologies (Mac OS and Safari browser), it was just critical that these reports stopped working.
Stack Overflow forum has got this gem of an article, which helped me in fixing this issue: SSRS 2008 R2 reports are blank in Safari and Chrome.
The original question was for SQL Server 2008 R2, but the solution works for SQL Server 2012 as well.
I am sure, some of you would face this issue in future, as more and more clients are moving toward different technologies other than Microsoft for day-to-day IT requirements, such as Linux, Mac, mobile OSes (iOS, Android, WP, etc.), but would still want all their BI solutions work as it would on native technology base (in this case, Microsoft).