export excel taking long time from ASP pages?
- by ricky
i am using following code for export to excel from .ASP page?
GMID = Request.QueryString ("GMID")
Response.Buffer = False
Response.ContentType = "application/vnd.ms-excel"
DIR_YR = Request.QueryString ("DIR_YR")
CD = Request.QueryString("CD")
YEAR = Request.QueryString("IND")
Problem that I am facing is that When records are around 2,000 or more{ export to excel ask for open option .When i click on that option only Download in progress... shown but actually no excel pop up will open .How can I fixed this bug because for 700-800 rows its working Fine.
I am not looking for whole change codes because there is a problem with only One Sale rep who is having more than 2000 rows.I am looking for one or two rows changes.