Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Exporting to Excel

Posted on by 333

When I Export some reports to Excel numeric data appears as "TEXT" and I  have to convert this to a number, is there any way to avoid this, is there a missing setup or parameter?

pastedimage1645463955927v1.png

Thanks in advance.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Exporting to Excel

    Hi 

    Unfortunately, seems like this is the only option. But I agree with you that numbers should be number. My suggestion is 

    1) Submit your idea here (or if you want I can do that) https://experience.dynamics.com/ideas/categories/list/?category=54db8819-83ed-e611-8105-5065f38a3bb1&forum=e288ef32-82ed-e611-8101-5065f38b21f1

    2) or I hope one of Microsoft employee here can bring this up to there team ( Marco Mels Andy Sather  and ... )

    Thanks 

  • MarisolC Profile Picture
    MarisolC 333 on at
    RE: Exporting to Excel

    this reports come naturally from analysis views (sales, inventory, purchases) nothing programmed here. Do I really need to change this with some coding?

    :(

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,536 Super User 2024 Season 2 on at
    RE: Exporting to Excel

    Hi, If you are developing with Excel Buffer, you can define the Cell Type when exporting.

    Cell type:
    More details: https://yzhums.com/4180/

    pastedimage1645493285313v1.png

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Exporting to Excel

    Hi

    I am in SaaS version. Below answer is for SaaS. I heard this is possible in On-prem through Excel Buffer or similar method (https://www.sauravdhyani.com/2021/07/business-central-14-export-to-excel.html

    I asked this questions before and the only answer I received is 1) I need to add Excel Buffer to report page 2) modify report layout. Hence, I never moved forward with either of them. 

    Recently Microsoft revealed the plan to add Excel Report layouts to reports. Lets hope this can be used for this purpose. 

    docs.microsoft.com/.../users-use-excel-design-layouts-reports

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans