Select the Tablix that you want to repeat column headers for by clicking on it.
At the bottom of the screen, find the “Row Groups” and “Column Groups” section.
In the “Row Groups” section, locate the top-outermost “static” row and click on it.
In the properties pane, you need to set the following TWO properties:
-RepeatOnNewPage = True
-KeepWithGroup = After
This will work for simple Header row if you have any other situation than you may refer below link
SQL Server 2008 Reporting Services Configuration Step By Step Image
Image 00
Image 01
Image 02
Image 03
Image 04
Image 05
Image 06
Image 07
Image 08
Image 09
SQL Server Reporting Services 2008
To Understand SQL Server Reporting Service check below link
http://shaikhnizam.blogspot.com/2009/08/sql-reporting-services-2008-faqs.html
Above Link Gives Conceptual Information about SQL Reporting Services 2008.
————————————————————————————————-
To Develop SQL server Report Please Download Following Tool
Tool is only use for simplification to develop an application otherwise we can also use inbuilt repot
Visual Studio 2008
Business intelligence Projects
-> Report Project
After Developing report we need to attach report in Asp.net .
For that we need Report Viewer Control.
————————————————————————————————-
To Download Microsoft Report Viewer
And Add After Installing this Report Viewer Control Add reference in web application and then Drag and Drop that Control on Webpage,
————————————————————————————————-
Above all steps needed to Develop and attach report in Application, but the main thing is ti Configure reporting service in SQL Server.
To configure SQL Server Report Server follow below Link
http://www.mathgv.com/sql2005docs/SQL2005ReportingServicesInstall.htm
Once the Report is Developed and Uploaded in Server we need to attached that Report in Application From Code
Sample Code to load RDL File From server
Import Namespace
using Microsoft.Reporting.WebForms;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl =
new Uri(“http://121.121.1.30:8080/ReportServer/”);
ReportViewer1.ServerReport.ReportPath = “/Employee”;
ReportParameter[] Params = new ReportParameter[1];
Params[0] = new ReportParameter(“EmpId”, txtEmpId.Text.ToString());
ReportViewer1.ServerReport.SetParameters(Params);
ReportViewer1.ShowParameterPrompts = false;
Or
http://forums.asp.net/t/1235370.aspx
————————————————————————————————-
Demo Video From Microsoft Site Can be seen from link
http://www.microsoft.com/sqlserver/2008/en/us/sql-reporting-services/default.aspx
Nilesh Rathod 