Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
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 | Talent 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 – email@example.com. 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