Sep 7, 2016

SSRS 2014 - IE 11 - Toolbar items may render in multiple rows instead of one row.

I have been facing issues with SSRS 2008 R2, The reports were freezing and not showing any data. Microsoft did not provide any support as SQL 2008 R2. MS anyways closed for any new enhancements SQL 2008 variants.

We upgraded to SSRS 2014, reports started working and data was rendered. Wait, now the toolbar started appearing in multiple rows. For smaller resolution screens, this was not acceptable. I could not find any solution or fix by Microsoft for SSRS 2014, though I could find a workaround that worked for me.

This workaround requires me to modify the ReportViewer.aspx file.

The ReportViewer.aspx file is located under Pages Folder at %ProgramFiles%\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\Pages. 

The folder name and path may differ based on the SQL Version and installation location, the path provided above is generalized.

  1. Take backup of original ReportViewer.aspx file, just in case the changes have to be restored.
  2. Open ReportViewer.aspx, 
    • find meta Tag
    • Replace the content property with content="IE=EmulateIE10; IE=Edge" in the tag
  3. Restart the SSRS service
  4. Try the report now, it should work
  5. It it does not work, then try different options in the content, example: IE=EmulateIE7 etc.

Changing this option will try to Emulate the Report with version specified in order.

3 comments:

Optimizing Indexes with Execution Plans

Contact Me

Name

Email *

Message *