I'm hoping to understand the behavior of SSRS a bit better in the following scenario (SSRS 2008). A single matrix (tablix) exists on the report. No other objects are on the report. That matrix is populated with 1.1 million rows of data
totaling about 200MB. Why does SSRS download the entire dataset prior to rendering the report's first page or am I missing something here?
When previewing the report, the local .data file bloats to 200MB indicating all dataset rows are being returned. The matrix does not contain any sorting, all cell "can grow" and "can shrink" properties are set to false, no expressions
are used anywhere, and even the table's column data types from which the data is being pulled are appropriate. In other words, I believe I've reduced storage and CPU needs while eliminating elements that add overhead when rendering a report.
The specific scenario here is a researcher previewing the first few pages of data then choosing to download the entire dataset. MS documentation I've read refers to "soft page breaks" when rendering as HTML and left me with the impression
that perhaps SSRS needs to know the entire height of the dataset before it'll slice the report into pages. It's odd to me though that it needs to download 1.1 millions rows of data befor
View Complete Post