Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Column Headers on each page

Author  Topic 

SunnyDee
Yak Posting Veteran

79 Posts

Posted - 2012-08-22 : 09:23:48
Hello:
In the tablix properties, I have selected the options for 'repeat columns on each page' and 'keep header visible while scrolling';
however it is not working.

Is there another setting that needs to be adjusted to keep the column headers while scrolling and print on each page?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-22 : 10:51:39
is the tablix inside another container or in a subreport?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

SunnyDee
Yak Posting Veteran

79 Posts

Posted - 2012-08-22 : 16:43:44
Thank you for your response. The tablix is not inside of a container or a subreport. Any ideas?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-22 : 18:01:34
are you rendering in html or excel format?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Angelflower
Starting Member

3 Posts

Posted - 2013-10-08 : 14:12:02
Does anyone have an answer to this question? I am having the same problem. I have all the right boxes marked but when I run the report from the Report Manager and then export as a PDF the header shows up on most of the pages but there are a few it does not and I have no clue why. tks!

Live well... be happy
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-10-08 : 14:32:08
quote:
Originally posted by Angelflower

Does anyone have an answer to this question? I am having the same problem. I have all the right boxes marked but when I run the report from the Report Manager and then export as a PDF the header shows up on most of the pages but there are a few it does not and I have no clue why. tks!

Live well... be happy

You need to do couple of things that may not be very intuitive. See here: http://vbcity.com/blogs/xtab/archive/2010/06/14/what-to-do-when-the-repeatcolumnheaders-property-in-a-tablix-isn-t-working.aspx

Sometimes you need all 3 things described there, but not always. So experiment.

Usually it is better to start a new thread when you want to ask a question rather than pick up an old thread. (Don't ask me why, I am a nobody on this forum who is just parroting what regulars, experts and administrators on the forum usually say )
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-09 : 00:03:45
quote:
Originally posted by Angelflower

Does anyone have an answer to this question? I am having the same problem. I have all the right boxes marked but when I run the report from the Report Manager and then export as a PDF the header shows up on most of the pages but there are a few it does not and I have no clue why. tks!

Live well... be happy


are you talking about report header or group header?


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -