Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Microsoft Dynamics NAV 2009: Professional Reporting
Microsoft Dynamics NAV 2009: Professional Reporting

Microsoft Dynamics NAV 2009: Professional Reporting: Discover all the tips and tricks for Dynamics NAV report building

eBook
€35.98 €39.99
Paperback
€48.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
Table of content icon View table of contents Preview book icon Preview Book

Microsoft Dynamics NAV 2009: Professional Reporting

Chapter 2. Creating a Report in the Classic Client

When Dynamics NAV 2009 was introduced, it also came with the capability to add a Role Tailored Layout for a report. The previous version had only the Classic Layout. This chapter is all about the Classic Layout, how to create it, and all of the capabilities of the good old Classic Report Designer.

The knowledge obtained in this chapter is required for when you migrate towards the Role Tailored Client or when you are already using the Role Tailored Client with the new report layout. This is because the Classic Report Designer is, currently, the starting point for the development of all types of reports in Dynamics NAV. First, we learn how to walk, then how to run and win the race.

In this chapter, we will learn about:

  • Using the report wizard

  • Creating a simple list report

  • Creating an Excel-like layout for a report

  • Printing a report to Excel

  • Report functions

The Report Designer


Reports are used to present information from the database, structure and summarize information, and print documents such as invoices. Reports can also be used to process data without printing anything.

Reports can be created or customized via the Report Designer, which can be found in the Object Designer.

The Report Designer is the development environment that is available in the Dynamics NAV Classic Client to create or customize report objects. It contains a data item designer to define the data model for the report, a section designer to design the layout of the report for the Classic Client, and a request form designer to create an optional request form in which the user can select options when running the report.

The workflow for designing a Classic report in Dynamics NAV 2009 can be visualized with the following diagram:

There are two ways to create a new report: from scratch or by using the wizard. I will start with an explanation of the report wizard and then dive...

Creating a simple List report


The first thing you have to do when you want to design a new custom report is create the data model. Where is the data coming from that I want to show in the report? Is it all in one table or do I need multiple tables? If there are multiple tables, how will I connect the records from the different tables? A good suggestion that I can give is to first make a draft drawing on a piece of paper of the layout of the report you want to create. Write down the fields that need to be visible on the report and then find out which table they are coming from. After that, if there are multiple tables find out how the tables are related and write that down.

This way, when you open the designer you already know what you need to do. Many novice and experienced developers make the mistake of not thinking before they begin. And then it can get confusing very quickly in the report designer.

Now that we have a good idea of the tables that we will require, it's time to open the report...

What is a ProcessingOnly report?


A processing-only report is a report that does not print but instead only processes data or C/AL code. Processing table data is not limited to processing-only reports. Reports that print can also change records. This section applies to those reports as well.

It is possible to specify a report to be "Processing Only" by changing the ProcessingOnly property of the Report object. The report functions as it is supposed to (processing data items), but it does not generate any printed output.

When the ProcessingOnly property is set, the request form/page for the report changes slightly, as the Print and Preview buttons are replaced with an OK button. The Cancel and Help buttons remain unchanged.

When the ProcessingOnly property is set you also cannot create any sections.

There are advantages to using a report to process data rather than a code unit:

  • The request page functionality that allows the user to select options and filters for data items is readily available...

Creating an Excel-like layout for a report


This is how the sections look like when you take the Work Order report into design mode:

When you look a little closer and click on one of the cells, you will notice that when you have a look at its properties, they are the properties of a Shape control. When you select a Shape control in the toolbox and put it on a section you can decide via the property ShapeStyle which type of Shape you are adding.

These are the possible values for the ShapeStyle property of a Shape control:

  • Rectangle

  • Rounded Rectangle

  • Oval

  • Triangle

  • NWLine

  • NELine

  • HorzLine

  • VertLine

You have to put the Shape control on top of the other controls (labels, textboxes) that contain the actual data. To do this you can select a Shape and bring it to front or send it to back using the Format menu on top of the report designer like this:

Tip

Overlapping controls

As you can see, putting two controls on top of each other can provide an added value. Another example of when this technique is applied is...

Report functions


Certain functions can only be used in reports. These functions can be useful for complex reports:

  • CurrReport.SKIP

    Use this function to skip the current record of the current data item. If a record is skipped, it is not included in totals and it is not printed. Skipping a record in a report is much slower than never reading it at all, so use filters as much as possible.

    A good trigger to use this function in is the OnAfterGetRecord trigger of a data item.

  • CurrReport.BREAK

    Use this function to skip the rest of the processing of the data item currently being processed. The report resumes processing the next data item. All data items indented under the one that caused the break are also skipped.

    A good trigger to use this function in is the OnAfterGetRecord trigger of a data item.

  • CurrReport.QUIT

    This function skips the rest of the report. It is not an error, however. It is a normal ending for a report. Also, the OnAfterReport trigger will not be executed if you use this function in...

Summary


In this chapter, we have covered the basics on how to create a simple report. We've seen how to implement sorting, grouping, totalling, and how to indent data items. You also have an idea on what's involved to be able to print a report to Microsoft Excel. And when you want to make changes or customizations to these kinds of reports it can quickly become complicated.

Furthermore, you should also have an idea by now of the limitations of the Classic report designer. A good example is the lack of colors at runtime. Also, the steps that need to be performed to have an Excel look and feel can become very tedious. Regarding the interactivity features of Classic reports, those are limited to what you can do with the request form.

A lot, if not all, of the shortcomings or difficulties that are inherent to the Classic report designer are solved, more intuitive and more user and developer friendly in RDLC reports for the Role Tailored Client.

The idea of this chapter was to give you a good introduction...

Left arrow icon Right arrow icon

Key benefits

  • Get an overview of all the reporting possibilities, in and out of the box
  • Understand the new architecture and reporting features in Microsoft Dynamics NAV 2009 with this book and e-book
  • Full of illustrations, diagrams, and tips with clear step-by-step instructions and real-world examples

Description

Microsoft Dynamics NAV is widely used in enterprises with its enhanced reporting features, but there still isn’t a book that covers reporting in depth, until now. This book will show you what’s possible and exactly how to develop reports for Dynamics NAV 2009. Learn why reports are designed in a specific way and then apply this knowledge to your advantage. Microsoft Dynamics NAV 2009: Professional Reporting is an essential guide to understanding the effort involved in creating reports in Dynamics NAV 2009, and all of the available reporting possibilities. Reading this book will result in a better understanding and it will help you save time during development.The book starts with an overview of what kind of reports you can create without a developer using charts, dimensions, and analysis views. The next chapter will introduce the new architecture of Role Tailored Client (RTC) reports and the basics on how to create them or have them generated. Moving on we will discuss data visualization, where you will learn how and when to implement all the available Visual Studio controls. Document reports and other types of specific reports are covered next, and you will get to know all the best workarounds for getting them to work correctly.Knowing other related features is vitally important to obtain a helicopter view of all the reporting possibilities of Dynamics NAV, and the next chapter will introduce Business Intelligence concepts and available technologies that could be used in combination with the Dynamics NAV database. Technology is evolving rapidly and new versions of Dynamics NAV are in the pipeline, so the book will also provide you with a view to the future and how to prepare for it.

Who is this book for?

Whether you are a Dynamics NAV consultant, developer, customer, project manager, or just interested in the reporting capabilities of Dynamics NAV, this book can provide you with information from a helicopter view down to the smallest details, tips and tricks, and workarounds. Empowered with the information in this book you should be able to master, analyse and deliver the most challenging reporting requirements in Dynamics NAV.

What you will learn

  • Create reports using RDLC technology in the Role Tailored Client
  • Use the Visual Studio Report Designer and customize it to meet your requirements
  • Develop Document reports
  • Estimate the time required to develop specific types of reports
  • Explore the hidden Dynamics NAV report capabilities
  • Use expressions to simulate conditional formatting in Dynamics NAV reports
  • Learn everything about Charts and Chart types in the RTC
  • Get a view of the other technologies in the BI world and how to integrate them to the Dynamics NAV database
  • Add interactive features such as Visibility Options, Interactive Sort, Document Maps, and Pictures to the report

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Oct 03, 2011
Length: 352 pages
Edition : 1st
Language : English
ISBN-13 : 9781849682442
Vendor :
Microsoft
Languages :

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Oct 03, 2011
Length: 352 pages
Edition : 1st
Language : English
ISBN-13 : 9781849682442
Vendor :
Microsoft
Languages :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 151.97
Microsoft Dynamics NAV 2009: Professional Reporting
€48.99
Programming Microsoft Dynamics NAV 2013
€53.99
Microsoft Dynamics NAV 2009 Programming Cookbook
€48.99
Total 151.97 Stars icon

Table of Contents

7 Chapters
Charts and Dimensions Chevron down icon Chevron up icon
Creating a Report in the Classic Client Chevron down icon Chevron up icon
Creating Role Tailored Reports Chevron down icon Chevron up icon
Visualization Methods Chevron down icon Chevron up icon
Developing Specific Reports Chevron down icon Chevron up icon
Other Reporting and Business Intelligence Tools Chevron down icon Chevron up icon
A View of the Future Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.6
(5 Ratings)
5 star 60%
4 star 0%
3 star 0%
2 star 20%
1 star 20%
Matthias Günther Feb 14, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
GUT
Amazon Verified review Amazon
Samuel Schnetzer Dec 30, 2011
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I would recommend this book to everyone that is into NAV Reporting.Very well-arranged with lots of screenshots.With this book the entrance/change to RDLC Reports is a lot easier.
Amazon Verified review Amazon
Daniel Rimmelzwaan Oct 14, 2011
Full star icon Full star icon Full star icon Full star icon Full star icon 5
If there is anything that you don't understand about reporting in Microsoft Dynamics NAV, then this is the book for you. Steven Renders delivers a must read book that includes step by step tutorials through the maze of different reporting options.In my opinion, this book sets the standard for reports training in NAV. Not only does it walk you through classic report design, it also explains how to properly develop RDLC reports. You will find out how to create the right dataset, how to get data into the header and footer sections. Finally it also gives you a glimpse into the future of reporting in Dynamics NAV.This book will give you the knowledge that you need to really understand how it works. EVERY NAV developer should have a copy.
Amazon Verified review Amazon
Bernd Jan 15, 2014
Full star icon Full star icon Empty star icon Empty star icon Empty star icon 2
Das Buch enthält Reporting Tipps für Dynamics NAV 2009 Role Tailored Client (RTC). Nicht für den Classic Client geeignet. Da habe ich versäumt, eine Leseprobe online zu studieren. Da Dynamics NAV 2009 aber mit beiden Clients ausgeliefert wird, halte ich einen Hinweis hierzu für wichtig. Andernfalls denkt man fälschlicherweise, dass beide Clients behandelt werden.
Amazon Verified review Amazon
Aliz Aug 05, 2012
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
This is a very well written book, but the low rating in this review comes about for the Kindle edition. The images in the Kindle edition are low resolution and completely unreadable. Zooming on the KT or even using the DX does not matter, the images can not be read on the Kindle.I am not sure if this is the publisher's fault and Amazon's fault, but they are both responsible for charging for unreadable material. Very disappointing, particularly that Amazon recently commissioned a survey on the use of Kindle. Did they not see what was selling already?This is my third review for a Packt Publishing text, and I have a number of them on Kindle. They all suffer the same fault.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.