Skip to main content

Notifications

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

Columns customization in Excel Report

Posted on by 94

Hi Guys,

I want to make an excel report,

For e.g.  I have two columns i.e Type and Vendor Name, if my Type is the same i.e. Item then I want to show each vendor name display in three different columns in excel report as per the below image.

pastedimage1679470663145v1.png

Let me know if there are any ways to do this.

  • Prathama Profile Picture
    Prathama 94 on at
    RE: Columns customization in Excel Report

    I want to display 'Price' from my customization page under each vendor name.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,296 Super User 2024 Season 2 on at
    RE: Columns customization in Excel Report

    Hi, After setting the required data in Dataitem, I think it should be possible to use Excel formulas.

    Here is a simple example, hope this can give you some hints.

    https://yzhums.com/23873/

    Thanks.

    ZHU

  • Hein Kruger Profile Picture
    Hein Kruger 501 on at
    RE: Columns customization in Excel Report

    Hi,

    You can do this by creating a report as normal, Set ProcessingOnly =True.

    Create a Header and Body Procedure:
    pastedimage1679851257456v1.png

    pastedimage1679851272762v2.png

    add a "CreateExcelWorkbook" procedure:

    pastedimage1679851330240v3.png

    add CreateExcelBook Procedure to OnPostReport Method.
    Add MakeHeader() to OnPreReport()
    Add MakeBody() to the OnAfterGetRecord of the DataItem that will be the repeater. (Like Sales line)


    How it works:
    The TempExcelBuffer Table is built first. After the report has run the Excel Worksheet is created and the TempExcelBuffer data is added to the Workbook. 
    You Should be able to get your result by playing around with the data items and adding more procedures.



  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Columns customization in Excel Report

    What is the figure you want to display under each vendor name?

  • Prathama Profile Picture
    Prathama 94 on at
    RE: Columns customization in Excel Report

    I have to Develop it, how can I do it.

  • Suggested answer
    AbhinavMehra Profile Picture
    AbhinavMehra 364 on at
    RE: Columns customization in Excel Report

    Hi,

    For this you need to contact your partner to build Report where he can use matrix concept for dynamic Vendor name and group by Type.

    You need to provide more details to them like from which table to you want to get data also.

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