Skip to main content

Notifications

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

How to add Dataitem link property in excel report for business central

Posted on by 153

Hi Guys,

I have created a excel report using excel buffer.

For example : I have used two dataitems .i.e. Student & subject.

I want to add Dataitem link in between these two dataitems.

Is there is any way to do this.

pastedimage1678341683636v2.pngpastedimage1678341515652v1.png

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: How to add Dataitem link property in excel report for business central

    hi

    To add a data item link between two data items in an Excel report created using Excel buffer in Business Central, follow these steps:

    Open the report layout in the Business Central Development Environment.

    In the Report Dataset Designer, select the data item that you want to link from (e.g. "Student").

    In the Properties window, expand the DataItemLink property.

    Click the ellipsis (...) button next to the DataItemLink property to open the Data Item Link Editor.

    In the Data Item Link Editor, click the Add button to create a new link.

    Select the data item that you want to link to (e.g. "Subject") from the "Data Item" dropdown list.

    Choose the linking method you want to use (e.g. "Inner Join").

    Specify the fields that you want to link on by clicking the ellipsis (...) button next to the "Link Fields" property.

    In the Link Fields dialog, select the fields from the "Left Table Fields" and "Right Table Fields" lists that you want to use for the link.

    Click OK to close the Link Fields dialog.

    Click OK to close the Data Item Link Editor.

    Save and compile your report.

    After following these steps, the data items should be linked in your report, and you should see the appropriate data in the Excel sheet generated by the report.

    DAniele

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: How to add Dataitem link property in excel report for business central

    Hello,

    We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    www.dynamicsuser.net/.../14

    I will open this up to the community in case they have something to add.

    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,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans