开发者

IE6 can't handle SSRS grid?

开发者 https://www.devze.com 2023-03-03 23:38 出处:网络
SQL Server 2008 DB, report server, and IIS all on same Win XP machine inside firewall. (Dev machine--production will be on a Win Server 2003 or 2008)

SQL Server 2008 DB, report server, and IIS all on same Win XP machine inside firewall. (Dev machine--production will be on a Win Server 2003 or 2008)

Test data is February, 21.5K records. Presumable other months will be similar.

Client and tester are Win XP SP3 with IE6. Long story, but can't change from IE6.

Report Server log shows that fetching, filtering, and rendering are all done within a little over one second开发者_C百科.

If the parameter settings are such that the result set is 3,117 records, Visual Studio renders in ten seconds, IE6 in about a minute.

For a larger result set (not sure exactly, probably around eight thou), Viual Studio renders in fifteen seconds OR crashes. IE6 hangs forever.

Same parameters, Chrome thinks it's done in fifteen seconds. Doesn't display grid, but export to Excel works.

Safari, Opera, Firefox all fail to do authentication pass-through.

Not yet able to try IE7/8/9/... due to requirement to have IE6 on development machine. (Not that it matters, since client can't use it but I wanted to compare).

Unless a resolution can be found, I am going to have to give the client a pre-formatted URI for an Excel dump and have her do the filtering in Excel.


Looks like there is no answer. We're starting to free ourselves from IE6, but IE7 and IE8 have the same problem. And we're kind of stuck with them because we use Sharepoint.

The report works on FireFox, but FireFox fails to pass authentication through to Sharepoint.

Opera and Safari retrieve all the data, but don't display it. (When the busy curson goes away, the window is blank except the toolbar, but the "dump to Excel" icon works!)

So, the sort-of answer is "The way to display huge amounts of data with SSRS is sometimes to not use SSRS"

I was starting to put it in another tool when the client decided other things were more important.

0

精彩评论

暂无评论...
验证码 换一张
取 消