Developing RDL Report for Business Central


Creating new report using visual studio for business central.

Dependencies :

  1. SQL Server 2016 Report Builder ( This can be found in the Prerequisite Components folder -> SQL Server -> ReportBuilder3).
  2. Visual Studio Code ( Latest Version).

Next :

Open visual studio code and create a new file

In Visual Studio code type treport and press enter.

Below is an example for the visual studio code.

report 50101 VendorList
  DefaultLayout = RDLC;
  RDLCLayout = ‘VendorList.rdl’;
  UsageCategory = Administration;
  ApplicationArea = All;
    dataitem(Vendor; Vendor)
       column(No_; “No.”){}

In the above two thing need to be taken care is the

  1. DefaultLayout -It should be RDLC.
  2. RDLCLayout – If contains the Name & the format .RDL (Report.rdl).

Defining the .rdl will create a rdl file for our report designing.

Once you have define all the related info into the report you need to build & publish the object.

This will create a Report.rdl file in you current project folder.

Before Publishing.


After Publishing – In the left pane (VendorList.rdl)


Now you need to design the Report layout using the report builder.

To do so go to the project folder and open the rdl file.


Below is the layout & dataset which are needed to design the layout of you report.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s