April 28, 2010 at 7:59 am
hi,
My report was dynamic report. It default contains 77 columns.
Case 1:
If the user selects 25 Columns and run the report from IE it shows dat & able to export to excel. Things are fine with this case.
Case 2:
If user selects 40-50 Columns and run the report,it shows data on screen but when export to Excel option its giving error.
Excel Limitations are:
<=256 Columns
<=65536 Rows
in my Case 77 columns and 50-55K rows of data.
My machine Config:
1GB RAM,2.6GHZ of,WinXP Prof.
Server Config:
Web Server: My web application is Deployed
512 MB Ram,1.79GHZ,Win2003 Server Enterprise edition
Database Server:
4 GB RAM, 3.00 GHZ Speed,Win Server edition
Could you please suggest me how to overcome this issue.
Thanks in advance....
Sasidhar Pulivarthi
April 28, 2010 at 12:50 pm
I'm not sure why it would say you are exceeding the limits unless you truly are. More than likely it's the columns rather than the rows that are giving you problems.
Do you have a header on the report? Any merged cells or cells that become merged cells when outputted to excel. I've found that when my header information does match up quite right with my datatable and footer information that excel will add a bunch of extra columns - some as small as 1 or 2 pixels - and then use merged cells to format it. This may be your problem, you may only be seeing 50 columns on the web
Additionally when you execute case 1 and everything is fine how many rows are there? ~55k or more or less than case 2? I'd suggest starting with case 1 and adding columns a few at a time until you get to your limit.
-Luke.
April 29, 2010 at 1:04 am
Thanks Luke...
For Case 1: The report contains same 55K data.
I verified the maxRequestLength in web.config file. It contains 4096.
I have to test against 50MB as maxRequestLength.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply