Pages

Social Icons

Wednesday 19 October 2011

SSRS Column header is not repeating???


SSRS Column header is not repeating this is a very common error in Sql Server Reporting Services.


Till now I am facing this issue in three conditions
  1. When I am not setting the It is a Tablix Member property.
  2. When I am using grouping in the reports.
  3. When I am using Subreports in the Reports.
Here is the solution of all three problems.
  1. Solution of first problem
For this follow these steps:
  • In the grouping pane, make sure to turn on advanced mode (click on the small black down arrow on the far right of the grouping pane
  • Select the corresponding (Static) item in the row group hierarchy
  • In the properties grid, set RepeatOnNewPage to true
  1. Solution of the second problem
Whenever we are using grouping in the reports in that case some times we are deleting the corresponding column. Then in the tablix structure in a report definition that do not have a corresponding visual representation on the design surface. When you delete the column that was automatically added when you defined a row group, you are deleting the part of the tablix definition in the report that controls the rows that are associated with the row group, including t he row that contains the column headings.

So For this problem did not delete that column just give the width 0.0 inch to that column and set visibility property of that column.
  1. Solution of the third problem
When we are using sub reports in our Reporting services that time in some cases column header is not repeating for this problem do one simple thing just delete the Table header and place that header in reports header with the proper alignment with reports. 

No comments:

Post a Comment