For report viewer, we are using telerik report viewer.
My report has 1 graph and one crosstab both using same data source, both graph and crosstab has expand/collapse option. Graph has a primary and secondary y-axes and 04 series i.e., 2 bar and 2 line. crosstab has 2 groups year and month.
Our report right now has 1 row for every day for the first 4 months of 2017, and in crosstab and graph we are grouping it by year and month to get monthly averages - It doesn't look like that data issue -
Expand/collapse option when used in graph doesn't seem to impact performance at all. The the report gets noticeably faster just by removing expand and collapse option from the crosstab,
I also noticed that it re-renders all over again and sends a call to storedprocedure every time I hit expand and collapse button in crosstab or graph and almost take same time to re-render, so it doesn't seems that it is using caching for this feature, however when report has multiple pages, it doesn't re-render and use cache to upload next page.
Please let me know if you need any other information regarding this