Collapse group and next group stays on next page

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.

Answer 1

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

Answer 2

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?

Answer 3

Hi jms1070,

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

Regards,
Simon Hou