Creating a list report

To create a report, we will use the report snippet and create the 50000 Radio Shows report.

Open Object Designer, select Report, and click New. The Report Dataset Designer is empty when it is displayed, so we need to add a Data Source (table) to the first blank row.

Type 50000 or Radio Show into the Data Source column:

If we want users to be able to execute our report from Business Central, we also need to enable a search so that they can find our report. We will do that using the UsageCategory and ApplicationArea properties.

More information on ApplicationArea can be found in the Microsoft Docs at https://docs.microsoft.com/en-us/dynamics-nav/applicationarea-property.

UsageCategory will determine where the report will be listed, and ApplicationArea will determine the access level a user requires to be able to execute the report:

Microsoft Docs has a good up-to-date explanation of the UsageCategory options (https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-al-menusuite-functionality).

The SourceTableName for our report is the Radio Show table. The columns are the fields from this table. Spaces and special characters are not allowed in column names for reports.

After selecting the columns and removing any unnecessary elements from the snippet, our report code should look as follows: