SSRS: How to Repeat Headers for Each Group

SSRS: How to Repeat Headers for Each Group

This article is going to share the information on
i) how to repeat headers for each group
ii.) how to overcome this error:

"An error occurred during local report processing .
The definition of the report '/Report ' is invalid .
The tablix 'Tablix' has a detailed member with inner members . Detail members can only contain static inner members ."


For example, consider the following sample data :

DECLARE @Tmp TABLE (Country VARCHAR(30),City VARCHAR(30),Population INT)
INSERT @Tmp SELECT 'India','CHN',100
INSERT @Tmp SELECT 'India','MUM',400
INSERT @Tmp SELECT 'India','KOL',300
INSERT @Tmp SELECT 'US','NY',100
INSERT @Tmp SELECT 'US','CAL',300
SELECT * FROM @Tmp

Create Data source (providing server name , login credentials & database name) and then create Dataset as shown below :




 Drag & drop List from Toolbox (or right-click on report body Insert - > List) on to the report body
and then drag & drop Table from Toolbox inside the List as shown below :




Then assign Dataset columns to the report Table columns :



After assigning columns , if we preview the report , we will end up with error as shown below :




Again goto the Design Pane, click on the List - > at the bottom , goto Row Groups - > =(Details) ->
in the drop down list click on Group Properties ... 
Under Group Properties , follow the settings as shown in images below:





Now again click on Preview pane, you will notice headers repeated for each group :



Leave a Comment
  • Please add 1 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Naomi  N edited Original. Comment: Minor edit

Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Naomi  N edited Original. Comment: Minor edit

Page 1 of 1 (1 items)