How to assign a display order of the tables in a single report in ssrs 2008

Question

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!

Answer 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.

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.