.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

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

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server


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

For Example:



Experience in Years




So I want to repeat


View Complete Post

More Related Resource Links

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.


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 - Drilldown - Grouping collapse/expand /title/header



I have been able to have a report with Group / Group count and Details.

The issue I have are:

1. When I collapse the drilldown to get only the Group and Group countit just collapse per page not the full report...I would like to have all Group / Group count on 1 or two pages and then epand as needed...

2. The title and column headers appear only on the first page... how to get it on all pages?

What is the "Linked Report" doing? Is it another kind of Drill Down..?

I need to have my summary report per OS for example shows only the OS Name then Count and if I click to expand I will have the servers in this group... but it seems working reverse way, I mean you have the details and if you collaspe you have the summary but this seems limited per page...



System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support

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.

PIvot Table in SSRS 2008

Hi All, Is there any data Region (Pivot) in SSRS 2008 or higher version? Our requirement is to show the report like excel pivot gererated from a OLAP Cube where we can select or unselect any dimesion attribute or measures. Thanks, IndiaSQl  

SSRS Table Header working differently in and out of print layout

Please help. This is bizarre and seems like a bug to me. Using a table in SSRS, I have a details row, with a parent group and finally a header row.  For my header row, I am referencing a particular cell in the parent group. I am doing this so that i can have the header row repeat on each page of the group. This works fine when I'm not in Print Layout mode. However, when i switch to print layout mode, or print the report itself, the data that is presented on the screen is different then what is presented when not in print layout mode. WHAT THE F*!@!?? I've been battling this for a while now and i'm at my wits end. Has anyone else experienced different results from when you are in print layout mode as opposed to being in print layout mode?

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?


help me plis. this thing drive me crazy. it really should be a simple solution but i cant find it, even with googling. i have subreport that display deposit transaction banking statement from account (customer). this subreport will be accessed through main report that loop all accounts in one branch, so its like a batch report processing for all customer in a branch. rendered to pdf and distributed to all our branchs. since i know that subreports header footer wont work on main report, i decide to move the subreport header into subreport table header and make it looks like it was a report header. but THERE is one problem i cant solve, there is ADDRESS BOX that should only VISIBLE on FIRST page for each customer, along with the other header that always visible. how im i supposed to do? please help. been searching n trying for 3 days and cant find any workin solution. been wondering do i really that dumm @_@ . thanks.   ps: sory for my bad english.  

SSRS Report - Page break after the Header when export to PDF



I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice. Within each invoice there is a header, body and footer.

My issue is after the header is printed, an automatic page break happens after the header, and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.

I wish any one can solve this issue and grateful if they can give the solution for my problem.




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.



SSRS 2008 - Fixed headers while scrolling - works fine for Matrix - but not for Table??!!


I have this feature working fine for matrix, but it does not work as expected for Table (Tablix).

I tried all over, and setting both check boxes in the 'Tablix Properties' dialog page 'Repeat header rows on each page' and 'Header should remain visible while scrolling' for both row header and column header, but none of it is working. Am I missing something?

In the properties table (F4) for text box of tablix, under 'Other' there is 'RepeatWith' - none / tablix: what is this used for? I tried this property also but I cannot get the headers fixed / visible while scrolling. I cannot get the 'column headers' repeat on each page of the report. Very frustrating...

Does anyone face similar issue? Can anyone help please? Do I need any update / download any fix? For now I have the following version installed for Visual Studio 2k8:
Microsoft SQL Server Reporting Services Designers Version 10.0.1600.22


Trouble Using More Than One LIKE Operator in a Table Filter in SSRS 2008


Hello All,

I'm having what I'm hoping will be a simple issue -

My co-worker has created a large report which contains several tables in SSRS 2008.  Each table is tied to one dataset, yet only certain data can be returned to each respective table.  Right now he's applying filters at the table-level behind each table, however as you can imagine this is not efficient because there is a LOT of data returning for this report. 

I'll try and give a simplified example -

There are two tables in the report body - one for containing products relating to both Cats and Dogs, and one for containing products relating to Birds.   Each product starts with the name of the specific animal - for example "Cats-Mouse Toy", "Dogs-Frisbee", "Birds-Rubber_Leaf".  

Now I need to somehow filter out each product so that they go to their proper tables.  As mentioned above, my co-worker was creating a specific filter for each product, but this is proving to be inefficient.  For example, there are 52 different products for Birds alone.  That would mean 52 different filter entries for each product.  What I would like to do is use the LIKE operator but i'm not getting the results I want on the first table.

So, on the first table I need something like:  =(Fields!Products.value LIKE &

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

Page Breaks within tablix (SSRS 2008)



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

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?


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