Working with RDLC Layouts
RDLC layouts are based on client report definition layout files (.rdl or .rdlc file types). The design concepts for RDLC layouts are similar to other layout types. The layout determines what fields to show and how they're arranged. However, designing RDLC layouts is more advanced than Word and Excel layouts.
Required tools
To modify RDL layouts, you can use either Microsoft SQL Server Report Builder or Microsoft RDLC Report Designer.
Report Builder is a stand-alone app installed on your computer by you or an administrator. With Business Central on-premises, Report Builder is automatically installed with the Business Central Server installation. For more information about installing Report Builder, see Install Report Builder in the SQL Server documentation.
RDLC Report Designer is an extension for Visual Studio 2017 and later. You can download and install RDLC Report Designer from the Visual Studio Marketplace.
Create and modify RDLC layouts
Creating and modifying RDLC layouts is an advanced task, which is typically done by power users or developers. The basic concepts aren't specific to Business Central report layouts. For this reason, we refer you to the following documentation:
-
This article explains how to create an RDLC report layout from AL code.
The links you to the SQL Server Reporting Services documentation for RDL/RDLC. This documentation explains the concepts
behind RDL/RDLC, and how to use Report Builder.
[!NOTE] Report Builder only recognizes .rdl file type;, not .rdlc. Layout files exported from Business Central are .rdlc file types. So to modify these layout in Report Builder, rename the file type to .rdl.
See Related Training at Microsoft Learn
See Also
Managing Report Layouts
Set the Layout Used by a Report
Get Started Creating Report Layouts
Working with Reports, Batch Jobs, and XMLports
Business Intelligence
Working with Business Central
Analyzing Report Data with Excel.
--- author: edupont04