SSRS doesn't display all the data when toggle option is used (only one page~1000

• sebekkg

  SSC Enthusiast

  Points: 127

  More actions

  January 6, 2023 at 11:24 am

  #4134468

  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.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  January 7, 2023 at 12:10 pm

  #4134890

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.