Hi,

Using SQL Server 2008 R2 and the Visual Studio Report Designer to design a local report (RDLC).

I am having trouble getting column headers to repeat on all pages. In particular, I have a report grouped by Route. If the Route group goes onto more than one page I need the Route to print again on the second and subsequent pages too, right now it only prints on the first page for the group.

I have found reference to accessing an Advanced mode in the Grouping Pane, but my Report Designer does not have this advanced option (see http://msdn.microsoft.com/EN-US/library/cc281455(v=sql.105).aspx).

The report is to look like this:

Route 1
Frank
John
Fred
- page break
Route 1
Jeremy
Asok

Route 2
Jeremy
Sheldon

Can anyone help me on this?