Sparkrock 365 logo
Sparkrock 365 logo
All Rights Reserved | Sparkrock © 2025

Search Results for

    Working with RDLC Layouts

    RDLC layouts are based on 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.

    Shows the different elements of an RDLC layout.

    Required tools

    To modify RDL layouts, you can use either Microsoft SQL Server Report Builder or Microsoft Visual Studio with the RDLC Report Designer extension.

    • 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 2019 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:

    • Create RDL Layout Report

      This article explains how to create an RDLC report layout from AL code.

    • Reports, Report Parts, and Report Definitions

      This links you to the SQL Server Reporting Services documentation for RDL/RDLC. This article explains the concepts behind RDL/RDLC and how to use Report Builder.

    Note

    Note:
    Report Builder only recognizes the .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 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.

    Find free e-learning modules for Business Central here

    All Rights Reserved | Sparkrock © 2025