How to Design Multi Page Report in SSRS 2008

Question

_{Wednesday, May 4, 2011 9:59 AM}

Hi All,

I have managed to create a multi page report. When I am preview mode i can see that the report has 2 pages.

But when I am in design view I cannot view the second page. How can I view the second page. Reason being I am trying to create a template where the table for certain data needs to be at the top of the page and some data at the middle and so on.

Thanks in advance.

Aash.

Aash

All replies (6)

_{Thursday, May 5, 2011 5:49 AM ✅Answered | 2 votes}

Hi Aash4,

According to your description, the behavior of cannot view the second page in design view is expected, in another way, there is only one page in design view.

Report Designer supports two views: Design to define the report data and report layout, and Preview to display a rendered view of the report. If you would like to show a table on the first page, and show the other table on the second page, you can add a page break on the first table like followings:

1. Click the gray handle in the first table, select “Tablix Properties”
2. Click “Add a page break after” check box under Page break options in General Tab

After do above, you can see the first table in the first page, and the other table in the second page.

For more details about report designer, please see the following article,
Working with Report Designer in Business Intelligence Development Studio: http://msdn.microsoft.com/en-us/library/cc281300(v=sql.110).aspx

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

Thanks,
Eileen

---

_{Thursday, May 5, 2011 8:42 AM}

Hi Eileen,

 

Thanks for your reply.

 

So how can i go about an place certain dataset data on second page at specific place like I want a dataset data to be at the bottom right hand corner of the second page and just above that I have to put a graph.

Hope this makes sense.

 

Thanks in advance.

Aash.

Aash

---

_{Friday, March 27, 2015 4:17 PM}

I just put an empty Matrix grid at the bottom (literally one cell) with no Borders at the point I want the page break..and then do as above.

This may well not be best practice.

Personally I would really like a view where you can force the Design view to be a particular page size so you can see whats happening.  I realize this is a non-trivial technical challenge given the dynamic matrix/table sizes

DBA

---

_{Friday, August 11, 2017 12:49 PM}

Amazingly, 6 years later this *still* seems to be the way to get a two page report.  Why not include a control called Page Break like every other reporting tool available?  ...and don't get me started on the lack of a checkbox control. 

Thanks, Mike Devenney

---

_{Wednesday, March 20, 2019 3:55 PM}

hi mike,

any exp on sap hana ssrs integration and passing prameter

---

_{Wednesday, March 20, 2019 3:55 PM}

hi 

any exp on sap hana ssrs integration and passing prameter