Hi,
I have created a document report in nav 2016 and used page header and page footer. when report run for more than one page the report header margin not freeze and body record started printing at header place for few lines. can someone please help me how to fix report header and footer in document report.
Thanks,
0
Answers
You'll find the answer here https://blogs.msdn.microsoft.com/robertbruckner/2008/10/13/repeat-header-keep-header-visible-in-tables-in-rs-2008/
Also, you can find more information about rdlc reports here https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tablix-data-region-cells-rows-and-columns-report-builder-and-ssrs
The report header always print on every page unless you set to FALSE the properties PrintOnFirstPage and PrintOnLastPage.
But as you said, header is visible on first page. So PrintOnFirstPage is TRUE. Now, double check that PrintOnLastPage is TRUE also. (how many pages you have on your report?)
If PrintOnFirstPage and PrintOnLastPage are both TRUE then I believe you're using Tablix Header instead of report header. So my previous answer will help you.
The report header is printing on every page. the problem is place of header is not as first page. when it print on second page the body record shifted up. That is the issue.
It could be reason that the layout width with left and right margins is more than defined page width. For example created layout width takes 19,7cm, defined page left margin takes 2,1cm, right margin - 2 cm and page size A4 width 21 cm x height 29,7, so total report width is left margin plus right margin plus layout width (2,1cm + 2cm + 19,7cm = 23,8 cm). 23,8 cm is more than defined page width 21 cm.
Solution reduce margins (recommendation for right margin always use 0cm). If it doesn’t help resize layout or change page sizes or format.
for Microsoft Partners