Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

DataItem not visible in Word report

Posted on by 382

Hey community, 

I have created a report extension for "Standard Sales - Pro Forma Inv" and I'm creating a dataitem in header but when I'm opening the word layout, the created dataitem is not in the XML Mapping Pane. I have also tried addlast, addbefore and addafter but it is not working. Kindly help

pastedimage1672910201994v2.png

pastedimage1672910281765v3.png

  • RE: DataItem not visible in Word report

    I didn't changed much but instead of using addfirst(Header) I used addfirst(Totals). As "Totals" was the last dataitem of "Header" in Pro Forma Invoice layout so it worked for me. Just make sure that the last dataitem is placed inside addfirst(). 

    Thank you.

    pastedimage1672988602820v1.png

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: DataItem not visible in Word report

    Thanks for confirmation, you can also put your solution here, so that it help others.

  • RE: DataItem not visible in Word report

    Thank you Steven for your help. My issue is resolved,

  • RE: DataItem not visible in Word report

    Hey Nitin, as it a default report and I'm just extending it so its layout is already defined. However, my issue is resolved. Thank you.

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,051 Super User 2024 Season 1 on at
    RE: DataItem not visible in Word report

    learn.microsoft.com/.../devenv-report-ext-object

    The report layout of an existing report can't be extended, only substituted. To use an existing report as a starting point, you can download the layout from Business Central and include it in the extension project.

    Layouts that are included in a report extension will show up in Business Central as built-in layouts. The layout in a report extension will not automatically be used when the report extension is deployed. To use the report extension layout, go to the Report Layout Selection page in Business Central, make sure to choose to use a built-in layout in the Selected layout field, and then choose the layout for the report in question from the Custom Layout Description drop-down box.

    You can automatically update a report layout from the error message that appears when you run the report by choosing the Yes button on the error message. Or, in advance of running reports, you can update specific report layouts or all custom report layouts that might be affected by dataset changes.

    Update Custom Report Layouts - Business Central | Microsoft Learn

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: DataItem not visible in Word report

    Hi,

    Have you added any report layout with .docx or RDLC?

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans