Developing RDL Report for Business Central

BREIF :

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

MyReport.al

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;
  dataset
  {
    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.

ReportDesignVS

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

ReportDesignVSrdl

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.

ReportDesignVSrdl1

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

ReportDesignVSrdl2

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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