SQL Server 2005 Reporting Services: Reports are Compressed

1
votes

I have a report that I am capable of viewing correctly in Internet Explorer (IE) with the help of Reports from SQL Server 2005 Report Server (SSRS). The problem is that the report is compressed to about 100px by 100px in Firefox and probably other browsers such as Safari and Chrome. Also, I am using IIS6.

How can a report be rendered properly in browsers other than IE with SSRS?

3
sql-server-2005web-applicationsreporting-servicescross-browser

3 Answers

2
votes

This is not a firefox issue it is a MS issue with how they developed reporting services (the web based portal to access your reports). It is not compliant with some rules of the Web community, hence the issues you see. The issue pertains to the usage of iFrames. In firefox the iFrame's height has a small default value. In Internet Explorer, iFrames automatically resize based on a document's height. Not so clever.

See this: http://forums.asp.net/t/1135437.aspx

As well as this: http://blog-mstechnology.blogspot.com/2009/08/sql-server-reporting-services-ssrs.html

Mainly this:

To Fix the Issue in Firefox, hope any one the following 2 ways will help us.

Step1:

  1. Go to the following Location, where SQL Server is installed ..\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\Pages

  2. Open ReportViewer.aspx File

  3. add the style property marked in bold and blue color, Then try this style="display:table; margin: 0px; overflow: hidden" ID="ReportViewerControl" runat="server" />

If not Helps the first step, then try the step 2.

Step2:

ADD the following code to the ReportingServices.css file (by default, it's found in "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Styles\"):

.DocMapAndReportFrame{ min-height: 860px;}

If you want Width also, then use this code

.DocMapAndReportFrame { min-height: 860px; min-width: 1000px; }

0
votes

I did following to ReportViewer.aspx and that help me Resolve the issue...

    <body style="display:table; margin: 0px; overflow: hidden; height:100%;">
    <form runat="server" ID="ReportViewerForm" style="height:100%;">
    <RS:ReportViewerHost style="display:table;" ID="ReportViewerControl" runat="server" />
0
votes

Just set the form height to 95% in Pages > ReportViewer.aspx