.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Page Breaks within tablix (SSRS 2008)

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server


page breaks seem to be a real issue in SSRS, according to the number of posts, but I haven't found a solution for my problem yet.

My report contains a tablix which is used to group the data by keys. The tablix has one column and one row, and this cell contains several subreports which get their data from another table depending on the keys of the groups. This works quite well. However, I would like to insert a page break in between the subreports. I tried inserting a rectangle with the PageBreak property set to Start and/or End, but this is ignored. Page breaks in the subreports themselves are also ignored. Having the subreports in rectangles with PageBreak property set to Start or End is ignored as well.

The only way I have found to force page breaks is cross-joining my query of the main report with a table containing page numbers, add the page number field as the last grouping in SSRS and check the "Page breaks between each instance of the group", then showing or hiding the subreports conditionally depending on the page number retrieved from the database. However, this obviously multiplies the amount of retrieved data by the number of pages and is therefore a rather slow approach.

How can I insert a page break between rows of a tablix or even within one row?

We are using the Report Viewer control in local processing mode

View Complete Post

More Related Resource Links

Can we show a line chart on multiple pages with page breaks? SSRS 2008


Hi there,

I am using SSRS 2008. I have a line chart which queries a huge dataset and shows the datapoints really close to each other that the labels and grid-lines are overlapping onto each other. http://oi54.tinypic.com/2vifrb9.jpg

Is there a way to split the chart and show it on different pages.? Thanks in Advance :)


SSRS 2008 - repeating a non column header column on every page

Hi - I am working on my first SSRS report and I have mostly all of it down except one issue. Per requirements, I need to display a column that is a non header column to repeat on every page while printing and or when I save the generated report in SSRS as a PDF file. I have seen some previous blog from 2007 where RepeatWith property is recommended to be set to the same name of the Tablix in which the column(s) are embeded, tried that but it is not working. Can any one help me on this or guide me how to resolve this? Thanks, Manny

SSRS 2008 group footer totals on a new page has a non-expected large cell height

SSRS 2008 group footer totals on a new page has a non-expected large cell height. When the group total is the first component on a new page, then this happens, but when it is part of the group on but not the first component, then it reverts to normal cell height. I have played with the advance settings now for hours, but cannot get this to work. Any ideas?  

How do you freeze the tablix header row in an Excel export file in SSRS 2008?

So this is totally killing me. I've found out how to make a tablix header row repeat on each page of a PDF export file in SSRS 2008 (which I won't even get started on because all I can say is that 2005 is way better), but I cannot figure out how to make a simple header row of a tablix freeze in an Excel export file.  The tablix is right at the top of the body and spans the entire width of the design area.  How in the world do you get it to freeze in the Excel export file?

Tablix header not repeating in SSRS 2008



I have a tablix header which is not repeating on each page. I have tried all the suggestions given for this issue in the forum but no luck.

for e.g: The repeat header rows in Tablix properties

Steps in Advanced Mode "RepeatonPage" etc.

I have a tablix with headers and two groups. The tablix structure is as below

Zone  Product Client Amount.

Here Zone is Parent group of product group. For both these groups i have tried the advanced mode suggestions. "Zone" Visibility is hidden in the report.


Thank you for your assistance.



How to Freeze page header SSRS 2008


Hi All,

Can someone tell me how to repeat page header on each page, i am using SSRS 2008.

Thanks in advance.

Font/letter spacing issue when printing from SSRS 2008 report page


We are developing reports in SSRS 2008.  When printing from the SSRS report page, we are seeing that that some text is "clumping" together or spaced oddly. I have tried a variety of printers so it's not printer-specific. If you export from the SSRS page to PDF or to Word and then print, everything prints as expected.

Nothing is as good as real text/names/data, but to reproduce, simply create several text boxes with...

I used several common fonts...
Arial, 10 pt (SSRS 2008 default)
Times New Roman, 12 pt (Office 2003 default)
Calibri, 11 pt (Office 2007 default)
Verdana, 11 pt
Tahoma, 11 pt

In the example above, I used normal weight, nothing fancy... If you use bold and underline, which is common for a page/column header or footer, this issue is even more apparent.

It feels similar to the following issue: https://connect.microsoft.com/SQLServer/feedback/details/482312/ssrs-report-font-rendering-issue

A workaround would obviously be to export to PDF and then print, but these are steps that our end users shouldn't have to (and won't want to) put up with to produce reports/invoices/etc. that ultimately go

Header Displayed For Hidden Tablix in SSRS 2008


I have inheritted a report which was written in SSRS 2005 and I am trying to migrate to SSRS 2008. It contains 2 overlapping tables - with different contents. Depending on a parameter selection either 1 or other of the tables is displayed. This is controlled via an expression in the visibility property of each table.

The display/no display of the tables works fine - but in 2008 an extra page with a header and footer is displayed for the 'invisible' table resulting in an unwanted page. Is there a way to avoid this and why doesn't it work in the same way 2005?


Sorting on a Tablix in a Matrix Report SSRS 2008



           This is the format of my report and I am trying to get the rows sorted.I do know about interactive sorting but I do not want to use it because this report will be called by an external web application and I want this report sorted before it is rendered to the user.

                                                                    A         B        C

Agree                                          4.0           23        45     10

Disagree                     &

Conditional Page Breaks in SSRS



Hi Everyone,

I have two tables in a report. My dataset brings back a field called "Page" with EACH and EVERY record. If I add a group to one table and group it to "Page" and check off the insert a breakpoint between instances of a group, the one table breaks to a new page at the right time, but because the second table shows less data, if i add it to the same group, I end up with page breaks at the wrong times.

It's supposed to resemble this

Page 1


Page 2


Page 3


Table Header (Title) Row need to repeat on each page. How to do this in SSRS 2008 & above?



I have a requirement, where 1st row (Hearder) should repeat on each page.

For Example:



Experience in Years




So I want to repeat


Blank page while exporting to PDF formate from SSRS 2008


Hi there,

I am getting every other page blank while exporting to the PDF format in SSRS 2008. I have checked the page size, page margin or anything that is crossing my page size.  Everything looks fine, and still I am getting blank pages.  Your suggestions will be really helpful.  Thank you in advance.


Blank Page at the end of Word Doument - SSRS 2008


Hi there,

        I have 3 RDL files, 2 Sub Reports(RDLs) and 1 Main Report(RDL). Sub Reports are inside Rectangle Container.

ON Main Report: The body of this RDL has border set.

I have used two tables each with only 1 row and column to  put two sub Reports in those two Tables respectively. The first table have property set, Add A Page Break After = True

The second Table has , Add A Page Break After = False

This report shows 5 pages when i generate it with PDF and shows page border too.

but, when i generate it with Word, page border is not present and takes 1 extra blank page at the end of the report. i.e total 6 pages when export to Word.

Any 1 Any Idea how to supress that extra blank page from Word document.






How to set WritingMode on tablix column on the fly in SSRS 2008?


I've tried setting the writingmode on a RDL I've created through the XML. I just can't display some table headers vertically. Can anyone help with what I'm doing wrong.

- <TablixCell>
- <CellContents>
- <Textbox Name="HeaderProduct645432219">

repeat row header on each page in ssrs 2008


Hi All,

 I am using Sql Server 2008 reporting services. I have a row on Group (tabular report), can anybody please tell me how to show report header while scrolling and on the each page.

Thanks in Advance.


Page numbering issue in SSRS 2008 R2 when converting to PDF

For rdl files created in SSRS 2008, the page numbering will render Page 1 of 0 but only for PDF.  Using OverallTotalPages instead of TotalPages only works on a 2008 R2 server.  On 2008, OverallTotalPages causes an error.

How do I get the page numbering to work on PDF without using OverallTotalPages?  I need to be able to change the files, do testing, then updgrade the SSRS instance.  I can't break existing SSRS 2008 reports.



Tablix headers not repeating in SSRS 2008


I have created a new report & add a table to it. When I select "Tablix Properties" and check on Columns Headers -> "Repeat Cheader columns on each page" the header columns do not repeat on each page. I also tried "Repeat header rows on each page". "Add page break before" seems to work ok. I am using VS 2008 9.0.30729.1 SP

I also tried deploying but it still does not work on the deployed version.


Interestingly, reports migrated from 2005 & unchanged seem to be ok.


Any ideas? Am I not setting soemthign up properly?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend