How to give tables heading in all page in ssrs report (Repeat on new page)

(0) Share

Report

Posted on by Community Member

Hi Experts,

How to give repeat on new page in ssrs report i have selected Advance mode and selected my table caption column under the property i have Repeat on new page : True,

after that when save this report that im getting error please give any solution.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

SamCha 18 on at

Like (0)

Report

When you set a static line to repeat, all the lines below it have to have the same setting.

So, say you have these:

Static1

Static2

Static3

GroupRows

You can't have Static2 to repeat without Static3 repeating too.

In your screenshot, there seems to be an empty static line between your header and the data, if you set it to repeat too it should work.

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

You need set the property on the row group, please check this link

www.sqlchick.com/.../repeating-column-headers-on-every-page-in-ssrs-doesnt-work-o.html

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

Check this out, it will help you for sure

www.cloudfronts.com/procedure-repeat-table-header-rows-every-page-report-dynamics-nav

This has always been challenging for many developers as there's a property in Tablix too which says Repeat Header Rows in every Page but eventually it doesn't work hence thats another way and it 100% Works.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Suresh,

Thank you for your reply i got a solution.'

Thank you

Was this reply helpful? Yes No
missssrs 5 on at

Like (0)

Report

Can you post the solution you came up with?

Was this reply helpful? Yes No