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

Excel report layout in business central via AL code

(4) Share

Report

Posted on by CU12031325-0

Hello everyone,
I am trying to create this layout in excel via AL code, But all columns are coming on one row only.

help me with this one pls.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Holly Huffman 6,554 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi there! Good morning, evening, or afternoon - depending on where you are :) Hope you are well today!

To create an Excel report layout in Business Central via AL code and ensure the columns are displayed correctly, follow these steps:

1: Define the Report Dataset

In your AL project, create a new report object or modify an existing one.

Define the data items and columns that will be included in the report. Ensure the dataset structure matches the desired layout.

report 50100 "Excel Report Example"
{
    DataItem(Item; Item)
    {
        Column(ItemNo; Item."No.")
        {
        }
        Column(Description; Item.Description)
        {
        }
        Column(SalesAmount; Item."Sales (LCY)")
        {
        }
    }
}

2: Create the Excel Layout

Run the report in Business Central and export it as an Excel file (data only).

Open the exported Excel file and design the layout:

Use separate rows for headers and data.

Add any formatting, formulas, or additional columns as needed.

Save the Excel file.

3: Add the Excel Layout to the Report

In the AL project, upload the Excel layout to the report object:

Use the ExcelLayout property to specify the layout file.

report 50100 "Excel Report Example"
{
    ExcelLayout = 'MyExcelLayout.xlsx';
}

Ensure the layout file is included in your AL project folder.

4: Test the Report

Publish the extension to your Business Central environment.

Run the report and verify that the layout displays correctly in Excel.

Troubleshooting

If all columns appear in one row, ensure that the Data worksheet in the Excel layout has the correct structure. Each column header should be in a separate cell in the first row.

Check that the dataset fields in the AL code match the metadata fields in the Excel layout.

hope this helps some!

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,324 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps.

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-excel-report-layouts?%3Fwt.mc_id=DX-MVP-5004336&tabs=any-report

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-howto-excel-report-layout?wt.mc_id=DX-MVP-5004336

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,206 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hope this helps as well: https://learn.microsoft.com/en-us/dynamics365/business-central/ui-excel-report-layouts?tabs=any-report

Was this reply helpful? Yes No

Join the conversation

Community site session details

Excel report layout in business central via AL code

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the March Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Excel report layout in business central via AL code

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the March Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates