April 2, 2014 at 12:26 pm
Anyone have a fix for this one?
We're trying to run a report and have a page break on the city row when it exports out to Excel.
At this point, the page breaks work fine with the export and the data tabs out by each city however, the issue we're running up against is the headers will not go into each tab now.
So what's basically happening is, the data exports out into Excel for each city, but the headers are missing for each city.
last thing, it's the second row in the tablix that it breaks out to.
April 3, 2014 at 12:56 am
I think u need set Property RepeatOnnewpage to True for each column. Thanks
April 3, 2014 at 5:48 am
Any time we change the column properties of the advanced section that contains the property you mentioned, we get an error stating that the properly must be set to false.
April 3, 2014 at 6:02 am
set repeatonnewpage to true for rows properties of the advanced section. Not for columns properties. I hope this helps.
April 3, 2014 at 6:18 am
Tried that but when exporting to excel, the table that has the row property repeatonnewpage set to true, the table does not show up on the other tabs in the worksheet.
April 3, 2014 at 6:19 am
I don't know if this is related or not but even though I have checked that the header rows repeat on each page....they do not repeat on each page.
April 3, 2014 at 6:33 am
Just now , I have done same task. Please look at images .thanks
April 3, 2014 at 7:10 am
Yeah I did the same thing but won't repeat on each page.
April 3, 2014 at 7:10 am
Hey nandu. Thanks for the info on this. not sure if Chris or I stated this on the post as well.
The way he has the report setup, it repeats on the second group in the Tablix, not the top group. Not sure if there's something extra he would need to do because of that, or, if it's not even possible because of it.
April 3, 2014 at 9:25 am
Hello all,
I was able to resolve this.
In addition to nandu.chowdary412's suggestion of changing the RepeatOnNewPage to True in the Row Groups AdvancedMode , I had to change KeepWithGroup to After.
Thank you!
December 4, 2018 at 9:23 am
In order to mitigate the issue of header/footer not appearing on the final tab when exporting to excel, i simply added a dummy tablix at end of report with page name set to EndOfReport. Of course the tablix required a dataset so i just grabbed one of the parameter pick list datasets i had since i wasn't going to be displaying any data. Would be more optimal if you created a dataset with simple select statement, e.g. "select 1". Anyone know if this export bug is fixed in newer version of SSRS?
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply