SSRS Report Builder Part 5.4 - Repeating and Scrolling Table Headers

[@olivierlacour1756]

Thanks for your exceptionally clear explanations of SSRS functionality. Helpt a lot :)

[@WiseOwlTutorials]

Happy to hear that you found it useful, thank you for watching!

[@BenjaminRowley-j9x]

Brilliant video! So much information packed into a such a short amount of time, without becoming overwhelming.

[@WiseOwlTutorials]

Thanks!

[@melvin9993]

A simply straightforward and effective way of training. Thanks for your time and effort in preparing and sharing these nice videos!

[@WiseOwlTutorials]

Thank you Melvin! Happy to hear that you enjoyed it and thanks for the comments!

[@paulinnocal2481]

Oh my God, I've been trying to figure this out for weeks! Thank you! You're right--the tablix properties options are extremely misleading!

[@WiseOwlTutorials]

Happy to hear that it helped! I still wish that it was more obvious!

[@alxvseti]

0:29 Start 2:10 Basic Table 3:43 The Problem 4:20 How not to Solve 6:00 The Grouping Panel 7:00 Selecting the Header Tablix Item 7:50 Making Headers Appear on Each Page 9:25 Creating a Table Header

[@aynellrodriguez7348]

OMG, It is as if you were watching me trying to make the row header appear by using the wrong options :) That is exactly what I was doing and not going anywhere, Thanks so much for this video it has helped a lot (like the rest of them).

[@WiseOwlTutorials]

No problem Aynell, glad you found it useful!

[@JDnotFlowers]

Outstanding and concise tutorial, brother. Thanks a million.

[@WiseOwlTutorials]

Thank you Joshua!

[@PlantBasedPietro]

AWESOME!!! Thanks for this!!! We have been trying to figure this out and have had no luck!!! Love this playlist!!! It has helped a lot. Thank you. :)

[@uppercuts6802]

Perfect tutorial, thanks mr Owl!.. In dept info, great explaination!

[@WiseOwlTutorials]

You're welcome Mr Neal!

[@archangel0071]

Thank you sir. I spent a few hours trying to figure out how to do the repeating headers.

[@ramalingamveluchamy6712]

WOW!!! Thanks for this!!! This is I want in my requirement. Thank you once again. :)

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@rosskingsford2404]

Just what I needed, thank you

[@indierevo3495]

Very good tutorial, helped me a lot.

[@WiseOwlTutorials]

Thanks! Happy to hear that you found it useful and thanks for watching!

[@feelinghappy7412]

THANKKKK YOUUUUUU SIRRRR ❤❤❤❤

[@WiseOwlTutorials]

You're very welcome!

[@jameschen434]

You are a hero!

[@WiseOwlTutorials]

:D thanks James!

[@charitomexico1830]

gracias!!!!!!! por fin solucione el problema con mis encabezados!!!

[@WiseOwlTutorials]

Happy to hear that the video helped you, thank you for watching!

[@keithdavis938]

Great video!

[@WiseOwlTutorials]

Thanks!

[@AbhisheakSaraswat]

Awesome video

[@NoPainNoGain61]

Thank you so much! Worked :)

[@WiseOwlTutorials]

No problem, happy to hear that it helped!

[@hugosantosRN]

Perfect !

[@WiseOwlTutorials]

Thanks!

[@kelseybenitez9505]

Thanks Really Helpfull :)

[@WiseOwlTutorials]

Happy to hear it, thanks for watching!

[@kelseybenitez9505]

Cool Video Brooo

[@WiseOwlTutorials]

Thanks! :D

I have an issue. I have a large table (about 18 inches wide with multiple columns). I have the first 3 row groups set to fixeddata and repeat when scrolling is working fine. However, when the user scrolls to the right AND also scrolls up, the headers for the first 3 row groups (that are fixed) do not repeat when scrolling, but the other columns headers do. This makes the visual of the report look awkward and messy. Is there a fix for this scenario?

[@phillipk9891]

Anything on creating a Paginated report (SSRS report builder) using PowerBI dataset. Somehow trying to add another column of same name but Query Designer does not allow that. Any ideas?

[@WiseOwlTutorials]

Hi Phillip! We started writing a course on Power BI Paginated Reports using Report Builder but it didn't generate any interest so we abandoned it. I do recall the query designer being pretty hopeless but you can write your own DAX queries directly in the Dataset Properties dialog box. This basic query will select a few columns from a table called Film in a published Power BI dataset, selecting the ReleaseDate column twice: EVALUATE SELECTCOLUMNS( 'Film', "Film Name", [Title], "Released On", [ReleaseDate], "Released On 2", [ReleaseDate], "Run Time", [RunTimeMinutes] ) I hope that points you in the right direction!

[@maxdrese149]

This works fine for me, however when I switch print layout the column headers do not appear on every page anymore. I want to export my report to powerpoint slides so I need it to repeat in print layout as wel. Can you help me?

[@WiseOwlTutorials]

Hi Max! I can't replicate this behaviour. The column headers appear when I view the report in print preview in the Report Builder application and when I export the report to PowerPoint from either Report Builder or the SSRS Web Portal running in Chrome.

[@sadenlav]

Hello Sir How to solve this problem? =Sum(Fields!DCTotal.Value, "DataSet1")+Sum(Fields!VatTotal.Value, "DataSet1") The expression used for the calculated field 'TotalAmount' includes an aggregate, RowNumber, RunningValue

[@jesper286]

My Static fields are below the Row Groups and not above them. So nothing happens when I make FixedData to True. How can I make it work in my report? I am using a Mastrix, not a Table, does that change the feature?

[@WiseOwlTutorials]

Hi Jesper, in a matrix you can use the Tablix Properties dialog box to fix the row and column headers. On the General page, check the boxes to "Keep header visible while scrolling". I hope it helps!

[@jesper286]

Thanks for reply, but it doesnt work. I think my issue is the same as below link, but when I click "FixedColoumnHeaders" to True in Geneal under Properties, I get this error "The tablix 'Tablix3' has an incorrectly set FixedHeader property on the opposite hierarchy, based on the property FixedColumnHeaders of tablix". If you have an idea to fix it, I would be happy. social.msdn.microsoft.com/Forums/sqlserver/en-US/6d6ad0d2-439e-458a-a64a-e427ca628a9e/reporting-services-2008-repeating-headers-when-headers-are-in-a-rectangle-in-header-cell?forum=sqlreportingservices

[@jesper286]

I fixed it by starting over. Not sure what I messed up in my old Tablix, but I started the new Tablix while fixing its headers and kept making sure that worked as I expanded the table.

[@WiseOwlTutorials]

@@jesper286 Glad to hear that you got it fixed!

[@cesteves6882]

Is there a way to relegate only 10 items per page in addition to having headers on each page?

[@WiseOwlTutorials]

Yes! See this video for how to control the rows on each page kzbin.info/www/bejne/pHO8n2R6ipiJg7M To make sure the headers appear on each page you may also need to set the KeepWithGroup property of the Static member to After as described here stackoverflow.com/questions/11285923/tablix-repeat-header-rows-on-each-page-not-working-report-builder-3-0 I hope it helps!

[@narakdk]

I cant have both FixedData and RepeatOnNewPage True at the same time. Whats wrong? It gives me an error

[@narakdk]

ok, I had multiple headline rows, so I had to make them all True within the Static area to make it work. Thanks

[@WiseOwlTutorials]

@@narakdk Hi there! You beat me to the answer! Happy to hear that you solved it and thank you for coming back to let us know!

[@pabeader1941]

It's pronounced Tāblix. It's a contraction of Table and Matrix. Table is long A, Matrix is long A so Tablix wound be long A also...