Expand all collapsed groups

Expand all collapsed groups

Posted by: loris.branca on 14 November 2023, 7:41 pm EST

• 

  loris.branca

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 November 2023, 7:41 pm EST

  I have a tablix with some groups collapsed, when I print or save I have the need to expand all rows.
  
  Is there the possibility to expand all the groups?

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 15 November 2023, 6:08 pm EST

  Hi Loris,

  You can introduce a boolean parameter for example ‘isPrint’, and use this value to set the hidden value for your collapsable rows. For example, if ‘isPrint’ is true set the hidden value for the rows to false else keep them collapsed.

  Then you can set the value of this parameter through code for when you want to print your report.

  Please find attached a sample report implementing the same.

  For setting the parameter value at runtime using code you may refer to Setting Parameter Values.

  Regards,
  
  Anand

  ReportForPrint.zip

• 

  loris.branca

  • Post Options:
  • Link
    Copy

  Posted 15 November 2023, 7:15 pm EST - Updated 15 November 2023, 7:20 pm EST

  Thank you Anand, for the Component Table it’s ok, in the row settings appears the Toggle item property in the section Visibility. But, when i use the component Tablix with row groups there isn0t any property in row settings.
  
  

  

  1785×526 81.3 KB

  

  907×683 35.8 KB

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 16 November 2023, 9:02 pm EST

  Hi Loris,

  The ‘Toggle Item’ property is available in the TextBox tab, you can click on the TextBox tab after selecting the row, as in your attached image where you’ll find the ‘Toggle Item’ under Visibility.

  Please find attached a sample implementing your use case using Tablix.

  Regards,
  
  Anand

  SampleReport.zip

• 

  loris.branca

  • Post Options:
  • Link
    Copy

  Posted 16 November 2023, 9:32 pm EST

  I did it, and it seems to work. The only bad thing is that by doing this the + sign remains on an already extended line, and when you close it the - sign comes out

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 19 November 2023, 7:43 pm EST

  Hi Loris,

  You can change the ‘Initial Toggle State’ of your TextBox that has the +/- sign to ‘Expanded’ so that it has a ‘-’ sign on an already expanded row.

  However, none of the signs will appear when you export your report to PDF.

  Regards,
  
  Anand