0

I have a report in ssrs 2008 including 2 different tables.

TABLE A    TABLE B

Both table are grouped by Name by adding a rowGroup. Note that there is also a page break "between each instance of the group" is enabled. So, When I run this report, it is running like:

------Page 1------
Name:X      Name:X
TABLE A     TABLE B
------Page 2------
Name:Y      Name:Y
TABLE A     TABLE B
------Page 3------
Name:AllName   Name:AllNames
TABLE A     TABLE B

However, I would like to put the table in an order. When Table A ends for all its group, then I want Table B to start. Example:

------Page 1------
Name:X     
TABLE A     
------Page 2------
Name:Y 
TABLE A
------Page 3------
Name:AllNames 
TABLE A       
------Page 4------
Name:X
TABLE B
------Page 5------
Name:Y
TABLE B
------Page 6------
Name:AllNames
TABLE B

How can I provide this? Any help would be appreciated!

Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82

1 Answers1

1

You can drag (or add) a Rectangle from Toolbox window to your report surface (like a tablix), then place the rectangle between the tables.

enter image description here

Right click it and select Rectangle properties, select Add a page break before. It will put a page break before render the rectangle.

I hope it has been useful.

alejandro zuleta
  • 13,962
  • 3
  • 28
  • 48
  • May I ask if there is any way to make it work when we put the tables like left-right (as in the question) instead of top-bottom (as ur answer) ? – Eray Balkanli Apr 18 '16 at 21:10
  • The result would be the same because page break works vertically as my answer and the expected result in your question. – alejandro zuleta Apr 18 '16 at 21:19
  • When I put the tables left-right and place the rectangle between them, this is not working in that case. It is bringing like -> (Page1)Name:X TableA - (Page2)Name:All TableA Name:X TableB - (Page3) Name:All Table B – Eray Balkanli Apr 18 '16 at 21:28
  • But if you put the tables up-down the result is like the example of the expected table in your question. – alejandro zuleta Apr 18 '16 at 21:33
  • Hey. I have an issue over there which is related to this issue. I appreciate if you check for me when you have free time. Regards. http://stackoverflow.com/questions/36865657/how-to-change-order-of-the-table-displays-page-number-to-keep-the-tables-seque – Eray Balkanli Apr 26 '16 at 15:03