question

db042190-2983 avatar image
0 Votes"
db042190-2983 asked AmeliaGu-msft commented

yet another repeating headers issue in ssrs

hi we run 2014 enterprise. usually when i look at the properties of static row groups and change the attributes as are shown here, https://social.technet.microsoft.com/wiki/contents/articles/19398.ssrs-how-to-repeat-headers-on-each-page.aspx (and a thousand other articles), headers repeat on pg 2 to N but not this time. very frustrating. as i recall nobody really understands this nuance in ssrs sufficiently to guide people. I'm trying below to share what i have going on here without sharing proprietary info. i've also tried setting the tablix's properties (repeat headers) and that didnt work either. and i did try to set the keep with group and repeat on new page static attributes on the 2nd and 3rd row group static objects but got errors. similarly i tried the same on the 1st column group static item and got errors. and i did try keep together with the other 2 attributes on the static row item and that didnt work either. The details group has no expressions etc in its group properties. also i did try throwing in fixed data true on one experiment but it didnt help.

146562-image1.png

146507-image2.png


sql-server-reporting-services
image1.png (18.4 KiB)
image2.png (14.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

db042190-2983 avatar image
0 Votes"
db042190-2983 answered

i spoke with one of my peers and she explained that back in the year 2012 some sort of upgrade was done here that left an unusual static row profile/hierarchy behind on an unknown set of reports. They didn't entertain the idea back then of going into/modifying the xml, so instead, on the reports they did try to fix, they rebuilt the tablix's from scratch to correct the problem. The report I referenced here wasn't one they addressed, it might not have even been known to be a problem.

During my conversation with my peer, she asked if static rows could be deleted. A light eventually went off in my head and i stared at the xml until it was pretty obvious what constitutes a static row in ssrs xml. I carefully changed the xml in a test copy of the report from the before "tablix row hierarchy" you see below to the after and was lucky enough to get this fixed. One of the authors out there does warn about the complications that can arise when there are multiple or nested hierarchies.

146567-beforehierarchyxml.png

146623-afterhierarchyxml.png




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

db042190-2983 avatar image
0 Votes"
db042190-2983 answered

here is the error i get when i try to set the 2nd static row 's attributes the same way. supposedly static items at the same hierarchy level should be set the same way but apparently not here.

146563-errorigetwhensettingstaticattributeson2ndstaticite.png



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Isabellaz-1451 avatar image
0 Votes"
Isabellaz-1451 answered

Hi @db042190-2983

Why in your row groups have 2 'Static' above the '=(Details)' ?Cause I see from your design report,there is only one row above the detail row
146679-screenshot.png

146694-my-test.png

Best Regards,
Isabella


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.





screenshot.png (10.8 KiB)
my-test.png (17.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

db042190-2983 avatar image
0 Votes"
db042190-2983 answered AmeliaGu-msft commented

hi isabella. my peer believes that an upgrade we did back in 2012 left some reports in this weird state. i don't have any more details than that and have to assume it would be difficult for someone to do this manually and on purpose. I have another post somewhere that shows proof of a corrupted rdl file right around or having something to do with a string value. the report still ran but if i'm remembering correctly whatever ssrs did restricted me in my ability to accomplish a change i wanted to do. if i can find that post i'll show it here. it might be on a different forum.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi db042190-2983,

Have you found the post?
In addition, you can also submit this issue to the Microsoft feedback at this link https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0
Your feedback is valuable for Microsoft to improve the level of products and service. Appreciate for your understanding.

Best Regards,
Amelia

0 Votes 0 ·