Wednesday, July 22, 2009

SQL Reports Report Viewer alignment issue in Firefox and Safari

Guys, i have faced an alignment issue with sql reporting services reports in Firefox and Safari browser. Below are the details of the issues and the solution that i could find. Hope this is helpful.

Issue in Firefox: Report frame width and height is shrinked to the top left.
Solution:
1. Go to Program Files → Microsoft SQL Server → MSSQL3 (Differs for different versions of sql server. Purpose is to locate "Reporting Services" folder) → Reporting Services → Report Server → Pages
2. Open ReportViewer.aspx
3. Modify as <> style="display:table; margin: 0px; overflow: auto"
ID="ReportViewerControl" runat="server" />

Issue in Safari: Report body is compressed to the left.
Solution:
This can be solved by placing a rectangle and including the tables / header elements present in the report in that rectangle.
The report layout should be modified in such a way that
1. all the header elements are included in a Rectangle.
2. all tables are included in a Rectangle.
There is no perfect solution for this. Hope microsoft fixes this in the latest versions.