ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: mshapiro on August 12, 2014, 11:12:28 pm

Title: Issue with exportExcel
Post by: mshapiro on August 12, 2014, 11:12:28 pm

I am having an issue with exportExcel in my ASP.NET application.  pqGrid is not sending a POST request to the controller if more than a certain number of records are displayed in the grid.  If I reduce the number of records displayed, either with filters or by changing the database query, then exportExcel works as expected.  I have determined that 2604 records (15 columns) is the maximum number that exportExcel will send.  This number increases if I reduce the number of columns in the grid.  This problem does not occur with ExportCsv.  I need help getting exportExcel to work correctly.  Thank you.

Title: Re: Issue with exportExcel
Post by: paramvir on August 12, 2014, 11:30:47 pm

you need to increase the POST request size on your server.

This post might be helpful.

http://stackoverflow.com/questions/15079397/maximum-default-post-request-size-of-iis-7-how-to-increase-64kb-65kb-limit

Title: Re: Issue with exportExcel
Post by: mshapiro on August 14, 2014, 10:05:05 pm

Increasing maxRequestLength resolved the issue.  Thanks.