How to convert Classic NAV report to Extension with Simplanova Report Converter

Andrius Pilkonis

Project Manager

Topic: Technical

Date: 8 Feb 2019

Dynamics NAV / 365 Business Central Extensions are a way for NAV developers and ISVs to extend the functionality of NAV without modifying Microsoft’s original source code.

Simplanova Report Converter automates conversion from Classic NAV report version to RDLC, but how about Extensions? This question is relevant to most of our customers and Dynamics Community. In this blog post, I will provide simple steps on how to convert Classic NAV report (I will use 206 Sales – Invoice report) to Extension in a couple of minutes.

Requirements:

  • Working Classic report with related tables;
  • Simplanova Classic Converter installed in NAV2018/Dynamics 365 Business Central with couple of license points;
  • Visual Studio Code with AL language extension.

Step 1:

Export Classic NAV report and related tables to .txt file (for example I used 206 Sales – Invoice report);

Step 2:

Convert Classic NAV report to RDLC format with Simplanova Report Converter:

Before converting, make sure that report works in C/Side

Step 3:

Open CMD and go to your NAV/Dynamics 365 Business Central directory example: cd C:\Program Files (x86)\Microsoft Dynamics NAV\130.CU2\RoleTailored Client.

Step 4:

Export converted report to new syntax (Delta file) : finsql.exe Command=ExportToNewSyntax, File=”<Directory>/<OutputFileName>.txt”, Database=”<DatabaseName> “, ServerName=<ServerName>, Filter=Type=report;ID=72206

Step 5:

Create your own txt2AL conversion line from template:

txt2al –source=”<Directory with your report> ” –target=”<Output Directory>” –rename –extensionStartId=50000

Grab your converted report from output directory and put it in AL solution.

Step 6:

For test purposes I created a new AL project with my converted report:

And first, build:

Ups.. something went wrong, from short investigation looks like ‘0’ now works like character, but in the layout we expect text. In dataset columns I replaced  ‘0’ to Format(‘0’):

Fingers crossed and…

Don’t forget to set ApplicationArea property for request page fields:

 

Find the steps mentioned above in a video

 

Hope this blog post was useful. If you have any questions, contact our team by email – sales@simplanova.com.

Simplanova Report Converter Demo

Please fill the form below and we will send You information How to Download Simplanova Report Converter FREE demo version.
  • Pingback: How to convert Classic NAV report to Extension with Simplanova Report Converter - Microsoft Dynamics NAV Community()

  • James

    Just an FYI, here is he command to use the development shell to export the object:
    Export-NAVApplicationObject “C:UsersDocumentsNAV DevelopmentNewSyntaxExportFilesRPT_206_Sales – Invoice.txt” -databaseserver -databasename -filter ‘Type=Report;Id=206’ -exporttonewsyntax

    SYNTAX
    Export-NAVApplicationObject [-DatabaseName] [-Path] [-DatabaseServer ] [-LogPath
    ] [-Filter ] [-Force] [-ExportTxtSkipUnlicensed] [-ExportToNewSyntax] [-WhatIf] [-Confirm]
    []

    Export-NAVApplicationObject [-DatabaseName] [-Path] [-DatabaseServer ] [-LogPath
    ] [-Filter ] [-Force] [-ExportTxtSkipUnlicensed] [-ExportToNewSyntax] -Username -Password
    [-WhatIf] [-Confirm] []

    DESCRIPTION
    The Export-NAVApplicationObject function exports the objects from the specified database into the specified file.
    A filter can be specified to select the application objects to be exported.

    • Andrius Pilkonis

      Good point, thank you for comprehensive comment 🙂

Related Posts
Read latest industry tips and news in our blog