The views and opinions expressed in this blog are those solely of the author(s) and do not necessarily reflect Microsoft’s current policy, position, or branding. For official announcements and guidance on Dynamics 365 apps and services, please visit the Microsoft Dynamics 365 Blog.
Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Business Central updates!Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features.
Download overview guide | Watch Business Central video
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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.
Export classic report and related tables as text (for example I used report 206 Sales – Invoice report);
Convert report to RDLC format with Simplanova Report Converter:
Before converting make sure that report works in C/Side
Export your converted report as text file.
Open CMD and go to your NAV/D365BC directory example: cd C:\Program Files (x86)\Microsoft Dynamics NAV\130.CU2\RoleTailored Client.
Export converted report to new syntax: finsql.exe Command=ExportToNewSyntax, File=”<Directory>/<OutputFileName>.txt”, Database=”NAV_1300_W1_Demo “, ServerName=ServerName, Filter=Type=report;ID=72206
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.
For test purposes I created new AL project with my converted report:
And first, build:
Ups something went wrong, from short investigation looks like ‘0’ now works like char, but in layout we expect text. In dataset columns I replaced ‘0’ to Format(‘0’):
Fingers crossed and…
Oh and don’t forget to set ApplicationArea property for request page fields:
Hope this blog post was useful and now you will be able not just convert Classic NAV report to RDLC, but also, to have the result as the Extension in a couple of minutes!
If you have any questions, contact our team by email – firstname.lastname@example.org. If you want to test Simplanova Report Converter – just submit the form below.
The post How to convert Classic NAV report to Extension with Simplanova Report Converter appeared first on Simplanova.
Business Applications communities