Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
tablix header

Navržená odpověď tablix header

  • Wednesday, March 06, 2013 7:02 PM
     
     
    Sign In to Vote
    0

    hi

    i dont hv any group in my tablix ,but i want my tablix header to be repeat in every page also my report header should be in just first page

    how to do that,

    for tablix i went to advance tab and then static ->i make repeatoneachpage to true ->it gives me error "Alltablix member must have repeat on each page property to false"

     

All Replies

  • Wednesday, March 06, 2013 10:49 PM
     
     Proposed
    Sign In to Vote
    0

    Hi,

    At the bottom of your report designer there should be the grouping info pane.  Click on the black arrow in the upper-right corner of the pane to enable "Advance Mode"  Doing this shows static group items in your grouping pane for things like header rows.  Find the static item that corresponds to your header row and check the property pane.  There will be a "RepeatOnNewPage" property, set it to true and headers should repeat, at least they did for me.

    Hint: If you can't figure out which static grouping could be your row header, watch the report designer as you click on the different groups, it will highlight the one you just selected in the designer.

    Excerpt from the following site:

    http://bignickolson.com/2009/03/11/repeating-tablix-headers-in-ssrs-2008/

    Regards,

    Zaim Raza.

     
  • Thursday, March 07, 2013 9:20 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Your second requirement is to display the Report page header only on first page.  Currently, it is not support to meet you requirement.  We can specify the visibility of the page header on first and last page by specify the “Print on first page” and “Print on last page” property.

    To work around this issue, you can move the content in the page header into the upper part of the report body and delete the report page header.

    Regards,
    Fanny Liu

    Fanny Liu
    TechNet Community Support

     
  • Friday, March 08, 2013 4:14 PM
     
     
    Sign In to Vote
    0

    It gives me error like " all the member of the tablix must have RepeatonNewPage property to false"