Page Caption missed on Navision report after Layout was modified with SQL report Builder

elflacodemiami · 2019-01-10

I reproduced the issue in 2015 and 2018. If you design for example Purchase Order report and change the layout with SQl report Builder, just to dragging the label "Purchase Order" to the left side of the Page Header, then the Page caption is missed, only print number 1. Also if you print at least 1 copy the second page prints fine the content of the text box ( Page: 1 )

elflacodemiami · 2019-01-10

Picture of the Page caption missed, only prints number 1

elflacodemiami · 2019-01-11

I did an extended research and found good articles
https://blogs.msdn.microsoft.com/nav/2011/05/19/rdl-report-design-reportitems-and-why-are-fields-not-shown-in-the-header-when-printing-works-ok-in-preview/
https://www.archerpoint.com/blog/Posts/dynamics-nav-2015-rdlc-report-heading-won’t-print
For me the trick was on the layout design the box I move to the middle of the page to the left it has this Value on the text properties =IIF(false,Code.SetData(ReportItems!HeaderData.Value,1),Code.GetData(41,1)). The Setdata was triggering late so I created another textbox and assigned this property to it and make it non visible
I hope this help the comunity

Page Caption missed on Navision report after Layout was modified with SQL report Builder

Answers

Categories