Monday, March 26, 2012

Reporting Services Reports In Firefox and Safari Browsers

Hi,1. We are using SQL Server 2005 Reporting services for creating reports for a many of our web applications. However, we find that the reports render correclty only in IE. When trying to view the reports in browsers like Safari or Firefox, the alignment of the report is totally messed up. Any way to fix this problem ? 2. We use the Report viewer control in the ASPX page to view the reprot. However, in many cases it is seen that the last part of the report is not visible. A scroll bar comes up for scrolling the report page, but it does not help. We have a header and footer for the page and we use Master Pages.3. Is there any other way other than enabling the 'Anonymus Access' in IIS to provide access to users to the reports craetd using reporting services ? Thanks and regardsRajendran Menon

Hi Rajendra,

Regarding reports not working on firefox, this a very common problem and there is no great solution available.

Browser Support for ReportViewer Web Server Controls -http://msdn2.microsoft.com/en-us/library/ms251673(VS.80).aspx

The reason for this problem is how report viewer renders the reports. Report viewer uses iframes to render the reports which is not supported by firefox. Check this post to get around this problem-

http://weblogs.asp.net/jgalloway/archive/2006/09/01/SQL-Reporting-Services-_2D00_-CSS-fix-for-Firefox.aspxIn our case we added dummy textboxes in reports so that there is no empty space horizontally in report. you will need to place empty text boxes in your report which spans the width of the report(in each section Header, Body and Footer).One other solution which can work is to turn off the asynchronous rendering (as reports will be rendered as html and not iframes) -http://msdn2.microsoft.com/en-us/library/ms252090(VS.80).aspx|||

Hi Joshi,

Thank you for the suggestions. We will give it a try and see if it works.

Thanks once again

Rajendran Menon

|||

Aj,

I'm wondering if I have another piece of the puzzle here...

When my website is deployed to a production server (with latest reportviewer control installed) then the reports all display crushed over to the left when viewed with firefox.

However.. and this is the whacky thing... when I run the website in visual studio on my desktop machine.. and point firefox at THAT.. then the reports display just fine...

So is it just that IIS renders the pages differently to cassini maybe?

On the server I'm running Windows 2003 server (SP2) .. on my desktop its just windows professional...

but anyway, the point here.. is that the reports render fine in firefox from visual studio.. but their width is totally screwed when deployed on a server...

Any ideas anyone?

Vida

|||

Hi there

I downloaded Reportviewer SP1 from the MSDN website and that fixed the column sizes!
http://download.microsoft.com/download/6/e/d/6eda0f6a-4fb3-4880-bd96-fe71d7c12aa0/ReportViewer.exe

No comments:

Post a Comment