Report and document layouts overview
A report layout controls content and format of the report. For example, the data fields in the report dataset that appear on the report, how they’re arranged, the text style, images, and so on. From Business Central, you can change which layout is used on a report, create new layout, or modify the existing layouts.
So many report layouts to choose from, so little time. Join us as we go through the details step-by-step to make sure we get the right one!
NAV SEALs are specialists in Microsoft Dynamics 365 Business Central and Microsoft Dynamics NAV, with more than 20 years of experience, in all areas of the application. We have a good business understanding and strive to design good, simple and robust solutions, specializing in troubleshooting and tailoring existing solutions and implementations.
A report layout sets up the following things:
- The label and data fields to include from the dataset of the Business Central report.
- The text format, such as font type, size, and color.
- The company logo and its position.
- General page settings, such as margins and background images.
You can set up multiple layouts for a report, and then switch between them to suit different reporting needs.
There are two important aspects of report layouts that influence how you work with them:
- The Layout Type indicates the kind of file that the layout is based on.
- The Layout Source indicates the origin of the layout.
Layout types
There are four types of layouts that you can use for reports:
- Word
- RDLC
- Excel
- External
Word
Word layouts are based on Word documents (.docx file type). Word layouts enable you to design report layouts by using Microsoft Word. A Word layout determines the report’s content – controlling how that content elements are arranged and how they look. A Word layout document typically uses tables to arrange content, where the cells can contain data fields, text, or pictures.
Excel
Excel layouts are based on Microsoft Excel workbooks (.xlsx file type). They let you create reports by using familiar Excel features for summarizing, analyzing, and presenting data with tools like formulas, PivotTables, PivotCharts, and more.
RDLC
RDLC layouts are based on client report definition layout files (.rdl or .rdlc file types). These layouts are created and modified by using SQL Server Report Builder or Microsoft RDLC Report Designer. The design concept for RDLC layouts is similar to Word layouts, where the layout determines what fields to show and how they’re arranged. However, designing RDLC layouts is more advanced than Word layouts.
External
An external layout type refers to an advanced type designed for specific reports. The reports and the layouts themselves are typically provided by partners, not Microsoft. The actual file type of the layout varies depending on the provider.
Layout sources
In addition to the type, layouts are further divided into three categories, based on their source or origin.
- Extension layoutsExtension layouts are layouts that are part of an extension installed in a Business Central environment. These layouts are typically standard layouts provided by Microsoft, for example, in the base application. Or, they could be layouts that are included in extensions from other software providers. You can identify extension layouts on the Report Layouts page because the Extension column shows the extension name and publisher.
- User-defined layoutsThe other source of layouts is the people who use Business Central. People with the right permissions can add new layouts in various ways. For example, you could start from an existing extension layout or a user-defined layout. You can identify user-defined layouts on the Report Layouts page because the Extension column is blank.Learn more in Get started creating report layouts.
- Custom layouts (obsolete)Custom layouts are also layouts that users create. The difference is that these layouts are created from the now obsolete Custom Report Layouts page, and they can only be Word and RDLC type. Although you can still create custom layouts, they’re being phased out in favor of user-defined layouts.Learn more in (Obsolete) Create and modify custom report layouts.
Contact us at info@NAVSEAL.com, visit NAVSEAL.com or connect with us on linkedin.com/company/navseal/ for all your Business Central needs!
