O'Reilly logo

Extending Microsoft Dynamics NAV 2016 Cookbook by Alexander Drogin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Including user interaction in reports

So far, the reports we have created have presented a static picture. Now let's take a step further and create an interactive report with dynamic dataset sorting and drill down to the underlying data.

Getting ready

File name in source files: REP50060_UserInteraction.txt.

How to do it...

  1. Open report 50010 Item Sales in NAV Report Designer. This report has no C/AL code, and it will not be required for interactive sorting and drill down, all work will be done outside the NAV reporting. Open the report layout in Visual Studio.
  2. We will enable sorting on all columns of the report, one by one. Let's start from the leftmost one - Item No. Select the field header (not the data row), right-click on it, and open Text Box Properties ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required