Announcements
No record found.
Hi everyone,
It is a processing only report it using for exporting data into excel. Is it possible to right align the highlighted data. I will run via account schedule page in business central.
Thanks in Advance.
That depends what technique you use for your Excel report.
Have you defined a report layout in Excel? If so you can do the formatting in Excel.
Thanks for the response,
but there is no layout available for the report (it's processing only report). It will export the account schedule details to excel.
Then you should create an excel layout or use the Excel buffer to export your data to Excel.
That gives you control of the formatting.
hello
I recommend this solution
learn.microsoft.com/.../ui-excel-report-layouts
DAniele
Hi,
Use Option Number in Cell Type as Bold for reference.
empExcelBuffer.AddColumn(“Sales Invoice Header”.Amount, FALSE, ”, FALSE, FALSE, FALSE, ”, TempExcelBuffer.”Cell Type”::Number);
Refer the below links for more info.
https://erpconsultors.com/export-to-excel-report-in-business-central/
https://erpconsultors.com/adjust-width-of-column-when-using-export-to-excel-functionality-in-d365-bc/
Regards
Amit Sharma
www.erpconsultors.com
Press Yes if info is useful.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,012 Super User 2026 Season 1
YUN ZHU 986 Super User 2026 Season 1
Teagen Boll 659 Super User 2026 Season 1
