Table starting in the next page.

Question

Hi, Im using Reporting Services 2005.

I have a report, and in this report there are several tables.

These tables bring information from an sql database. They display many rows of data.

I have this scenario:

When running the report, in Page 1 i got:

Table1 with its rows of data.

Table2 with rows of data.

In Page 2 i have the continuation of the rows from Table2.

But i would something like this:

Page1:

Table1 with its rows of data.

Page2:

Table2 with its rows of data.

What im trying to say is, i don't want a table starting in the middle of a page. When a table starts, i want it to start at the beginning of the page.

How can i do this?

Thanks.

---

pyram

Answer 1

Hi Pyram, 

Right click on the 2nd table and go to tablix properties.  Select "Add a page break before".  That will take the 2nd table to a new page.

Hopte this resolves your issue.

Good luck

---

regards Natraj www.BItipsntricks.com Mark as Answer, if it is answer for your Question. Vote as Helpful, if it is helpful to you.

Answer 2

Hi Pyram, 

Right click on the 2nd table and go to tablix properties.  Select "Add a page break before".  That will take the 2nd table to a new page.

Hope this resolves your issue.

Good luck

---

regards Natraj www.BItipsntricks.com Mark as Answer, if it is answer for your Question. Vote as Helpful, if it is helpful to you.

Answer 3

Hi pyram07,

In your case, I think we need to add a page break to “Table1”. For detail steps, please refer to the article below:
http://msdn.microsoft.com/en-us/library/ms156434(v=sql.90).aspx

After add a page break to “Table1”, the table2 records will start with a new page.

Regards,

---

Bin Long

TechNet Community Support

Answer 4

thank you all!

---

pyram