I have issue in SSRS where I have a report for some indicators, but underneath some of the indicators I want to display detailed info rows for that indicator. Because of that I used toggle option so I don't see rows of detailed info rows unless I need them. And everything is on this one page which is ok.
But issue comes in a case where there is almost 2000 rows for detailed info for certain indicator and when I expand tablix I don't see all the data but only 1400 rows for example and don't see anything what was after that tablix in the report.
When I try to display data without toggling option there is about 50+ pages instead of only 2 (I think SSRS want's all tablix's content to be on 1 page which in this case can't be done and everything else on the rest).
Is there a solution for this?
I tired grouping of data and putting option page break after new group but no luck.