Notifications
Announcements
Hii Guys,
I want to create excel report using excel buffer. Also I want to run that report on global search in business central.
For example :- I want to show student list. i.e. ,No, Name, Address.
Is there is any way to do this.
hi
look this
learn.microsoft.com/.../devenv-howto-excel-report-layout
daniele
I don't recommend to use the Excel Buffer, it seems way to complex to achieve a simple Excel layout.
Instead create a report, with a normal dataset and then add an Excel layout to it.
Here are some examples/tutorials:
How do I: Create an Excel Layout Report? – think about IT
Quick Tip: Get started with Excel layouts for BC here: aka.ms/bcexcelsamples – think about IT
Hi, just adding some info, hope this helps as well.
Excel Buffer: https://yzhums.com/4180/
Excel Layout: https://yzhums.com/23873/
But as Steven mentioned, these two methods are independent and generally don't mix. Excel Buffer is only used to export data and cannot correspond to the layout. So it is recommended to use Excel layout.
Thanks.
ZHU
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,173 Super User 2026 Season 1
Dhiren Nagar 1,201 Super User 2026 Season 1
YUN ZHU 1,164 Super User 2026 Season 1
