Develop report datasets

Path: Analytics, business intelligence, and reporting > Develop reports > Develop report datasets · tier official · system reporting · narrative reviewed (checked by Opus)

Overview

This section is for AL developers who build reports and need their datasets to perform well. It has two pages: a reports overview and a collection of performance articles for AL developers.

Start with Reports overview. It explains how reports print, display, and process data, and how the dataset, the layout, and the request page work together. It also covers report extensions and discoverability. Layout options are Excel, Word, and RDL, and you can design them visually.

Then read Performance Articles for AL Developers. It covers efficient page design, web services, reports, AL coding patterns, data access optimization, and testing. Use it to tune the datasets and code behind your reports and the rest of the application.

Key points

• Reports can be used for printing, displaying, and processing data.
• Reports are built using datasets, layouts, and request pages.
• Layout options include Excel, Word, and RDL, with visual layout design.
• Report extensions and discoverability are covered in the overview.
• Performance guidance covers pages, web services, reports, AL coding patterns, data access, and testing.
• Specific performance topics include page background tasks, Edit-in-Excel, query objects, partial records, table extension impact, and event subscriptions.
• The performance articles reference 2021 release wave 2, 2023 release wave 1, and 2023 release wave 2.

Learn pages

• Performance Articles for AL Developers: Learn how to write efficient AL code, pages, reports, and web services, and use tools like the AL Profiler to improve performance in Business Central.
• Reports overview: Use reports to display information from database to structure and summarize information and print documents, such as invoices.

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.