THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jorg Klein

Microsoft Data Platform MVP from the Netherlands

SSRS – Static column headers in a Matrix

How do you create a static column header centered above your dynamic columns? One way to try achieving this is to place a textbox above your dynamic columns. One thing is for sure, the textbox will never be on the perfect centered location and what if the number of dynamic columns grow or shrink?

Thing you need to do is to create a static column group. You do this by adding a new column group to the matrix and give it a static expression, for example: =”static”
Now make it the top group by clicking Up for the static column group on the Groups tab of the matrix’s properties. You can also achieve this by just dragging the column group up in the layout view.

The result, a centered and perfect aligned column header with the text “YTD” above some dynamic columns containing years:

Published Wednesday, July 16, 2008 3:28 PM by jorg
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS




Thanks a lot!!!

It worked perfectly.

But one thing - is there a way to hide the header of the other column?

October 1, 2013 2:40 AM

Ram S said:

Thanks for valuable information

May 5, 2015 8:31 AM

Adan JR said:

Thanks man for the tip.

From Mexico

October 14, 2015 6:45 PM

Banketeshvar Narayan said:

Could you please assist me how to open "Matrix Properties" window? I didn't find any window from where I can move group columns UP and down.  

March 25, 2016 2:11 AM

Leave a Comment


About jorg

Jorg Klein, Microsoft Data Platform MVP from the Netherlands.
Privacy Statement