SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Column Headers on each page
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SunnyDee
Yak Posting Veteran

76 Posts

Posted - 08/22/2012 :  09:23:48  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 08/22/2012 :  10:51:39  Show Profile  Reply with Quote
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

76 Posts

Posted - 08/22/2012 :  16:43:44  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 08/22/2012 :  18:01:34  Show Profile  Reply with Quote
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 - 10/08/2013 :  14:12:02  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3588 Posts

Posted - 10/08/2013 :  14:32:08  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 10/09/2013 :  00:03:45  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000