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, 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
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
look this
learn.microsoft.com/.../devenv-howto-excel-report-layout
daniele
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…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Nimsara Jayathilaka. 4,252
Rishabh Kanaskar 4,117
Sumit Singh 2,956