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)

Suggested answer

Holly Huffman 6,530 Super User 2025 Season 2 on at

Like (0)

Report
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 95,599 Super User 2025 Season 2 on at

Like (0)

Report

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. 20,439 Super User 2025 Season 2 on at

Like (1)

Report

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

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November 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

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates