报告控制的excel导出限制是多少？ [英] What is the limit of export to excel for Report Control?

问题描述

我正在尝试导出到excel。

报告查看器似乎可以呈现小行数（< 30K - 行），但是当我尝试导出更大的尺寸（> = 50K - 行）时，它会超时我。< br>
sql语句只需15秒即可获取此数据。但渲染似乎在10分钟后调整出来

任何建议都将受到高度赞赏。











"h2_lin">解决方案

你确定报告查看器正在为你而死吗？我认为excel的每页限制为65k行。

根据报表的设计方式，DB中的50k行并不总是等于50k行才能出类拔萃。

要测试这个，在那里扔几个分页符。我相信如果有分页符，报告查看器会在Excel中生成一个新工作表。

Hi,

I am trying to export to excel.

Report Viewer seems to be rendering ok for small row count (<30K - rows) but when I try to export larger size (>=50K - rows)
it times out on me.

The sql statement only takes 15 sec to get this data. But the rendering seems to be timming out after 10 mins

Any suggesion will be highly appreciated.



Thanks,

Anthony Desa

解决方案

you sure it's the reportviewer that's dying on you?  I think excel has a limit of 65k rows per sheet.

And depending on how your report is designed, 50k rows from the DB doesn't always equal 50k rows to excel.

To test this, throw a few page breaks in there. I believe the reportviewer generates a new sheet in excel if there is a pagebreak.

这篇关于报告控制的excel导出限制是多少？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！