With the release of the NAV Development Preview – February Update, a new version of the VSIX was released (al-0.14.17461.vsix) that allows you to create the RDLC and WORD layouts for a report with one click.
Let’s look at an example. Here I created a report.al object with the following dataset:
You can use the TREPORT snippet and then fill in the blanks to do this.
At the top you will notice the following:
RDLCLayout = ‘layout/RDLCReport.rdl’;
WordLayout = ‘layout/MyWordLayout.docx’;
This means I want to have the layouts for my report to be stored in a separate layout folder.
Smart solutions 4: Integrate NAV with an Azure Machine Learning Model in less than 10 steps
NAV Development Preview – February Update
Generate Symbols in a Modern Development environment with Microsoft Dynamics NAV 2018
SQL Operations Studio (preview) is a free tool that runs on Windows, macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure SQL Data Warehouse; wherever they’re running.
SQL Operations Studio (preview) is built on top of Visual Studio Code and offers a lightweight, keyboard focused modern code workflow experience when working with SQL.
It has the following capabilities:
You can download your (preview) version here: https://docs.microsoft.com/en-us/sql/sql-operations-studio/download
After you install and run it, you will see the following screen:
Then, when you connect it to a SQL Server instance it shows the following:
And… you can find it on GitHub here:
There are a lot of really cool features in SQL Operations Studio, like for example creating Insight widgets…
Insight widgets take the Transact-SQL (T-SQL) queries you use to monitor servers & databases and turns them into insightful visualizations.
Learn more about it here: https://docs.microsoft.com/en-us/sql/sql-operations-studio/what-is
How amazing is this!