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 Monday, April 09, 2012 4:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 7:55 PM
Points: 1, Visits: 4
Siva Gurusamy (4/7/2009)
for SSRS 2008,
KeepWithGroup After /KeepWithGroup
RepeatOnNewPage true /RepeatOnNewPage
KeepTogether true /KeepTogether


You can actually set all these in the Properties Pane if you go to Advanced Mode, ridiculously accessed by a tiny drop down arrow at the right of the COlumn Groups header.

The following shows how to access Advanced Mode.
[url=http://snippetsandhelp.blogspot.com/2010/07/ssrs-repeating-column-headings-not.html][/url]

A bunch of gray <Static> boxes will appear in the Row Groups pane above your named row groups. For each <Static>, I set the fields as indicated by Siva in the Properties Pane, and headers are now appearing on all pages.

Thanks.
Post #1280500
Posted Thursday, March 28, 2013 9:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 04, 2013 2:35 PM
Points: 92, Visits: 189
So it seems that everyone figured out how to do this for 2008, I am still on 2005 and when I try the repeatgroup header it fails to produce the header on each page
Post #1436557
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse