BC Observatoryunofficial, made by waldo
topic hubReporting & Analyticsofficial - Microsoftreviewed - checked by Opus

Develop reports

Report development in Business Central: building report layouts (Word, Excel, RDLC, external, composite) and report datasets in AL. It answers how to create, edit, import, export and assign layouts, how datasets, layouts and request pages fit together, and how to tune report-related AL code.

Open in Claudedevelop-reports.md

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

Overview

This section covers the two halves of a Business Central report: the dataset, which is defined in AL, and the layout, which presents the data. The top-level page introduces creating and customizing layouts in Word, Excel and RDLC formats and developing datasets with AL.

Two subtopics go deeper. Develop report layouts covers layout types, designing and mapping fields, themes, header/footer layouts, choosing which layout a report uses, and available fonts. Develop report datasets gives an overview of building reports from datasets, layouts and request pages, plus performance guidance for AL code, pages and web services.

Start with the overview page to see how the parts connect. Then go to the datasets pages if you are defining report data, or to the layouts pages if you are designing or assigning a layout.

Key points

  • Layout types covered: Word, Excel, RDLC, external and composite.
  • Layout tasks include creating, editing, importing, exporting and assigning layouts to reports.
  • Default layout configuration and choosing the layout a report uses are covered.
  • Themes and header/footer layouts are covered, along with font availability and font management.
  • Datasets are developed in AL and combined with layouts (Excel, Word, RDL) and request pages.
  • Performance guidance for AL developers covers AL code, pages and web services.
  • The dataset subtopic has 2 pages and the layouts subtopic has 9.

Subtopics

More Learn pages

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

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

What Learn documents here 8 of 12 Learn pages

Show 4 more