Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Repeating TABLE Header on each page of the report when you print the exported to excel report. Expand / Collapse
Author
Message
Posted Friday, May 22, 2009 10:36 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 11:07 AM
Points: 16, Visits: 571
In source code find : TablixRowHierarchy

Under : that you will find following piece of code


After


Add 2 lines:

true
true

New Code :

After
true
true



Done
Post #722209
Posted Friday, May 22, 2009 10:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 11:07 AM
Points: 16, Visits: 571
In source code find : TablixRowHierarchy

Under : that you will find following piece of code

1)
2) After
3)


Add 2 lines:

1) true
2) true

New Code :
1)
2) After
3) true
4) true
5)



Done!!!!!!
Post #722214
Posted Friday, May 22, 2009 10:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 11:07 AM
Points: 16, Visits: 571
In source code find : TablixRowHierarchy

Under : that you will find following piece of code

TablixMember
KeepWithGroupAfter/KeepWithGroup
/TablixMember

Add 2 lines:

RepeatOnNewPagetrue/RepeatOnNewPage
KeepTogethertrue/KeepTogether>




Done
Post #722218
Posted Monday, May 25, 2009 1:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, January 30, 2014 12:45 PM
Points: 339, Visits: 716
Hi :)

Please try using the property "RepeatOnNewPage" and keeping the same as "True".

Thanks alot,

Niraj
Post #722867
Posted Wednesday, October 28, 2009 4:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 09, 2009 4:13 PM
Points: 1, Visits: 31
Thanks!!!! Works perfect in SSRS 2008. :)
Post #810403
Posted Sunday, November 01, 2009 8:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 14, 2010 9:09 AM
Points: 141, Visits: 187
Hi. I think you can have a try of RAQ Report.
1. It can help you to export report to Excel. You just need to select the function in the menu in the report IDE.
2. With it, you can set the display style of page header as you like. The only thing is selecting desired style in the dialog box.


RAQ Report: Web-based Excel-like Java reporting tool
Post #812110
Posted Friday, December 18, 2009 11:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 20, 2010 11:00 AM
Points: 55, Visits: 18
Hi,

I tried to add these element below the Tablix Row, It resulted in an error saying that these properties are not in the scope. The element tablix row in namespace..... has invalid element keepwithGroup. This is how I added in the xml code.

<TablixRows>
<TablixRow>
<KeepWithGroup> After </KeepWithGroup>
<RepeatOnNewPage> true </RepeatOnNewPage>
<KeepTogether> true </KeepTogether>
<Height>0.25in</Height>
<TablixCells>

Anyone has any other idea to fix this rather than re-building the report. this report was built in SSRS 2005 and migrated to SSRS 2008. Now I cant revert back to fix this issue.
Post #836546
Posted Wednesday, January 06, 2010 7:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 17, 2010 3:41 AM
Points: 2, Visits: 15
WOW, That actually work!

It took a little time to understand the hierarchy there since it look like there was an unnecessary hierarchy in the xml.

I played with it a little and it work.

Thanks a lot pal,
Roy.
Post #842814
Posted Thursday, March 11, 2010 8:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 24, 2013 11:43 AM
Points: 3, Visits: 7
Hi All,
If its SSRS 2008, make available the "Grouping window" by right clicking on report and selecting "Grouping" from menu.

1. Select "Advanced Mode" ( click on small arrow on right corner of grouping toolbar) this will display all rows of tablix control.
2. Click on the desired static row and press F4 to display properties window.
3. Set "RepeatOnNewPage" to "True" and
4. Set "KeepWithGroup" to "After"
5. Set the property same for all static row in same hierarchy i.e if you have 3 rows before group header in tablix then you need to set these properties for all. otherwise SSRS will display an error.

thanks
Post #881032
Posted Thursday, April 01, 2010 1:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 11, 2010 2:28 PM
Points: 1, Visits: 17
Awesome Siva. It works for me in SSRS 2008.

Thanks.
Post #895255
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse