Microsoft Dynamics 365 Business Central Cookbook

How to do it...

1. Open up your AL project in Visual Studio Code. In the Explorer, right-click and select New File. Name the file Television Shows Report.al. This report will be a simple list to show the records from the Television Show table you added earlier.
2. Now, we need to define the structure of our report dataset.

You can use the report snippet to quickly create the basic structure of a report.

Select the new file and, in the Editor tab, enter the following code:

report 50100 "Television Shows Report"{    UsageCategory = ReportsAndAnalysis;    ApplicationArea = All;    DefaultLayout = RDLC;    RDLCLayout = 'Television Shows Report.rdl';    dataset    {        dataitem("Television Show"; "Television Show")        {            RequestFilterFields = Code, "First Aired", "Last