Posted 10 Dec 2010
Link to this post
Some reports I need might be up to 2000 pages, mabye 100,000-200,000 data rows. There are billing reports, mostly numbers and sums, no pictures. I'm getting an error with over 1,000 rows, but that is probably due to my weak test server with not much memory. The number of pages it can display depends on the amount of memory on the server right? Sounds like 2,000 pages will be a problem no matter how much memory I have on the server.
It really doesn't have to display it though, I could popup a message saying, 'report is too large to display, dumping to pdf'. Would it be possible to just dump the report format to PDF? Most of our clients just care about printing the reports, not looking at them. I really like the telerik report designer. Will SQL Server reporting services have this same issue?
We also have 1 report that might combine a bunch of subreports and be a total of 50,000 pages that the client would print out. I'm guessing that would have to be written to pdf somehow, or is there a way to keep sending subreports to the printer?
Also it really doesn't matter if it's on asp.net or the silverlight viewer, it's still the same issue right?