SSRS – Repeat Header Rows On Each Page – Not Working


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.

VAIDY

Advertisements

SQL Server 2012 Reporting Services on Safari & Chrome Browsers


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).

VAIDY

Complete list of Microsoft Dynamics GP 2010 R2 SSRS Reports


Inside Microsoft Dynamics GP has listed out all SSRS reports for Microsoft Dynamics GP 2010 R2.

The list categorizes reports by module and indicates whether it’s a normal report or KPI based report. This would be the best document to make us aware of and convince our customers that GP does have such expansive list of standard reports and KPIs.

VAIDY