SSRS Show column headers on all pages in SSRS Report

Select the Tablix that you want to repeat column headers for by clicking on it.

0

 

At the bottom of the screen, find the “Row Groups” and “Column Groups” section.

1

 

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

2

This will work for simple Header row if you have any other situation than you may refer below link

http://sqlserverpedia.com/blog/sql-server-bloggers/repeating-column-headers-on-every-page-in-ssrs-doesn%E2%80%99t-work-%E2%80%A6or-does-it/

 

Advertisement

SQL Server Reporting Services 2008

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

http://www.microsoft.com/downloads/details.aspx?FamilyID=dbddc9b6-6e19-4d4b-9309-13f62901b0d5&displaylang=en

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

http://www.microsoft.com/downloads/details.aspx?FamilyID=cc96c246-61e5-4d9e-bb5f-416d75a1b9ef&displaylang=en

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