RDLC Reporting

During the training we will build several reports which highlight the main headaches we encounter when transforming reports and creating new reports. We will focus heavily on the flattening of the dataset and how to do multiple nested tables and grouping in Visual Studio. This is where people are struggling.

The instructor will also talk about when and when not to use Code.getdata and Code.setdata, which is heavily used in the standard document reports. The instructor will give tips on how to modify the standard document reports, which pretty much all customers want changed. We will also explain in details the best practice for creating RDLC reports, and get each student through the minefield of Visual Studio, and increasing the development speed for all participants.

Even though you have worked with RDLC reports before, this class will dramatically increase the speed when designing RDLC reports. Everything is explained in these 2 days, if not explained during the 2 days you can ask the instructor for free, after participating in this training.

Target Audience

Microsoft Dynamics NAV partners and customers, working with NAV 2013/2015/2016 reporting.

Course Outline

Day 1

  • Understanding the new NAV Report Dataset Designer
  • Understanding the creation of the dataset
  • Visual Studio 2013 Report Designer, which of the many buttons can we use
  • Filtering and Visibility best practice and how to easy debug these
  • Understanding how to do groups, both simple and advanced groups
  • Understanding how to use scope for expressions
  • Understanding how to use custom code in reports
  • List, Rectangle and Table controls explained in details
  • Tips, tips and then some more tips for how to speed up the creation RDLC reports

Day 2

  • Working with OfflineReports, making it easy to design reports with data in customers live database, but not work directly in the Live database
  • How to base Reports on the new Query object
  • Create well performing reports
  • Understanding Code.SetData and Code.GetData and when to use ReportItems
  • When to use Visibility on List, Rectangle, Table or Row. Visibility requires many hidden tricks
  • When and when not to use Visibility in Headers and Footer
  • Working with Images and transparency, and how to get 1 image control work for all document reports and multiple companies with different logos
  • Printing to PDF, Word and Excel, what are the differences and what is supported and what is not
  • Exploring the new Report features introduced in NAV 2013 R2 – NAV 2016
  • Tips, tips and then some more tips for how to speed up the creation RDLC reports

And more

  • Working with templates so reports can be done in minutes
  • Upgrading Classic document reports from 5.0 to NAV 2013 R2
  • Designing the Document reports the “right” way
  • Working with copy and page loops
  • Exploring many time consuming pitfalls when designing reports in Visual Studio and eliminating them with easy workarounds
  • Using parameters to change the look and feel of a document report, making 1 report object work for multiple customers, excellent for Multi-Tenancy
  • How to create Transheader/Transfooter RDLC in NAV 2013 R2 and have this work when printing multiple document reports
  • Tips, tips and then some more tips for how to speed up the creation RDLC reports

The instructor will share many reports with examples you can take home and explore. Our instructor loves to be challenged so if you are struggling with a complex report bring it to the class and put him on the spot for how to solve your issue.


Claus Lundstrøm


January 26 & 27, 2016 – Registration