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 1Frank
John
Fred
- page break
Route 1Jeremy
Asok
Route 2Jeremy
Sheldon
Can anyone help me on this?