Open Forum

Expand all | Collapse all

Page Caption missing from a Report after modify layout with SQl Report Builder

  • 1.  Page Caption missing from a Report after modify layout with SQl Report Builder

    Posted Jan 10, 2019 05:01 PM
    Edited by Carlos Garcia Jan 10, 2019 10:11 PM
    ​​This happen in all version, at least I tested in 2015/2018. The issue is when you design the layout of a report with SQl report Builder and Drag a Text Box to another place of the session, Example The Purchase Order Label, then some text Boxes does not show on the Header, example Page caption Page Number:1 is missed and the  Addresses fields
    Attaching an screenshot and file using Windows Steps Recorder.
    ---------------------------
    Carlos Garcia
    Software Developer-IT
    Ferd. Schmetz Needle Corp.
    Miami FL
    ------------------------------


  • 2.  RE: Page Caption missing from a Report after modify layout with SQl Report Builder

    Posted Jan 10, 2019 10:18 PM
    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%E2%80%99t-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

    ------------------------------
    Carlos Garcia
    Software Developer-IT
    Ferd. Schmetz Needle Corp.
    Miami FL
    ------------------------------