I have a stored procedure when executed generates a record of 42000+. (Using Stand Alone Report Designer) calling the trdx in the UI - report viewer I have no problem, it generates successfully in 2 mins compose of 1500+ pages.
The problem is when I tried to export it into excel. it lags and it cannot successfully export the file.
I wonder if anyone can help me about this. Thank you.