Collapse group and next group stays on next page RRS feed

  • Question

  • I have a group that is by customer and I have it defaulted to show expanded view when report is first opened. The expanded view showing all the details spans all the way to the end of page 1 so that the second customer shows up at the beginning of page 2.  When I click to collapse customer 1 so it is now only 1 row, I want to see customer 2 right below it, not have to move to page 2 to see the next customer.  Is there a way I can get this to work?  I guess I'm looking for it to repaginate somehow on collapse or something along those lines.

    Wednesday, October 8, 2014 4:29 AM


All replies

  • Hi jms1070,

    According to your description, you want to apply page break when expand rows in a group. Right?

    In Reporting Services, we can't put any expression to apply logic in page break property. Also the collapse/expand can't be used as field in expression. In this scenario, it's only possible for the first group spanning page 1 when the page size is same as the heights of the details rows within first group. If you set the page break between each group instance, the group 2 is always on page 2. So it's impossible to repaginate based on collapse/expand. Your requirement can't be achieved currently.

    If you have any question, please feel free to ask.

    Best Regards,
    Simon Hou

    • Proposed as answer by BI_Support Saturday, October 11, 2014 2:40 PM
    Thursday, October 9, 2014 2:06 PM
  • Well, I'm not really looking to apply page break on expand. I am looking for group 2 to be pulled in to page 1 when group 1 has been collapsed. But your point may still apply.  Is that also not possible?
    Friday, October 10, 2014 8:13 PM
  • Hi jms1070,

    It's not possible unless the group 1 part exactly displayed in page 1.

    Simon Hou

    Thursday, October 23, 2014 2:08 AM