SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Repeating TABLE Header on each page of the report when you print the exported to excel report.


Repeating TABLE Header on each page of the report when you print the exported to excel report.

Author
Message
mohaninperson
mohaninperson
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 14
Excellent. Creating report from report wizard has different meanign than creating manually. This is i got it today when i was trying to get the report table headers in each page after adding the group ie based on group i was tring for data in different page.
Your suggestion really helped.
Thank you.
Karin Zirk
Karin Zirk
SSC-Enthusiastic
SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)

Group: General Forum Members
Points: 111 Visits: 586
Thank you very much. All I needed to do was change this:
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<TablixHeader>
<Size>2.275in</Size>

to this:

<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<RepeatOnNewPage>true</RepeatOnNewPage>
<KeepTogether>true</KeepTogether>
<TablixHeader>
<Size>2.275in</Size>
kpsr_kpsr 63487
kpsr_kpsr 63487
SSC-Addicted
SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)SSC-Addicted (423 reputation)

Group: General Forum Members
Points: 423 Visits: 473
Hi

Select table>>>>Go to Table Properties>>>>>>>there u can see the option "repeat header rows on each page">>>>select the option(screen shot attached).Then header will be display in each page(even when u export)

Please let me if u have any doubts

sank
Attachments
Disney_01.jpg (163 views, 125.00 KB)
althotos
althotos
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 23
Thanks.
I had worked with Visual Studio 2005 building Reports, where you could turn on the repeating Table Column Headers from inside the table properties. Working with 2008, I'm surprised at a lot of the functions that have been removed for Report Builder, including the repeating Column Headers if you use an existing report as a template.

I had to use the Wizard to rebuild the table so I could get the repeating column headers. I copied over the header and footer sectopms from the report I was working on. What a pain. Thanks Microsoft (not).
Gaurav.Vinodkumar
Gaurav.Vinodkumar
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 165
Please review the post below which talks about same issue

http://gauravsqlserver.blogspot.com/2011/03/repeat-tablix-row-header-on-each-page.html
althotos
althotos
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 23
Fantastic.
I just fixed an older, existing report using your directions.
Thanks a lot.
the.eviled209.40k
the.eviled209.40k
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 11
Hey, I wanted to thank you for this tip! It worked perfectly, and I knew nothing about xml going in. So thanks!
imurluv210
imurluv210
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 4
This one worked for me like a charm....
Thanks.... :-)
Moorthy SP
Moorthy SP
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 86
Thanks the time saver.. :-)
virtualjosh
virtualjosh
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 98
Adding the three properties suggested above has worked for me in the past, but it didn't work this time, when I had a Column Group in my Header.

I added a parent Group to my first column and repeated the headers per Group. It worked, but wasn't exactly the layout I was looking for.

Then I researched how come it works when you use the wizard and not when you add the item manually. Interestingly enough I have an identical report in which case the Header also has a Column Group and headers DO repeat. So I figured I wasn't doing something right.... I compared both XMLs and found the following properties:

</TablixRowHierarchy>
<RepeatColumnHeaders>true</RepeatColumnHeaders>
<RepeatRowHeaders>true</RepeatRowHeaders>

These are the properties controlled via the Tablix Properties panel.

If I add <RepeatRowHeaders> to my bad report's XML, SSRS deletes it. It won't let me add the property. However, you I tried adding both directly onto the XML and it worked.

So also try that.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search