I have a ReportViewer(C#, asp.net 4.5).
My query returns over 700'000 rows of data but it takes forever for the report viewer to show(it does not show, I think report viewer rendering is extremely slow).
Is there a limitation for the report viewer data?
Has Anyone here have experience of showing several tens of thousands of pages on the ReportViewer?
Application Architect with 10 years experience developing in C#
How many columns of data? Is there a need to load 700K rows of data at once? I would page the data, or load on demand. Probably only a few hundred can be reasonably viewed at a time. Maybe load the first couple pages and load on demand the rest as scroll is activated. This can be done server side or client side depending on your implementation and configuration.