Goodbye NAV-REPORTING blog

To make it more simple for you guys to find and discover blogs post from the NAV team members we are combining our blogs into the NAV Team Blog, so we will no longer be posting on the NAV-REPORTING blog. All post from this blog have already been migrated to the NAV Team Blog. If…


Printer Selections in Role Tailored client

Today Printer Selections Form 64 is not transformed to Printer Selections Page 64 since virtual table 2000000039 is not accessible from Role Tailored client. I thought of different options for how we could get page 64 to work and decided to try the new Client Extensibility feature in NAV 2009, although this could also be…


Send email with PDF attachment in NAV 2009

In this post I would like to explore the possibilities to create an email from the Role Tailored client and attach an invoice as a PDF file to the email, unfortunately we have do not have this functional build into our Demo application, but let me show you how this can be do with little…


Microsoft Dynamics NAV 2009 SP1 ready for download

We have now released Service Pack 1 for Microsoft Dynamics NAV. So you will now all be able to use the new Reporting features in this Service Pack. Previously I have described all new reporting features in this Service Pack. Please find all these features described here: What is new in Dynamics NAV 2009 SP1…


Building a Matrix Report in Microsoft Dynamics NAV 2009 SP1

The final Service Pack 1 for Dynamics NAV 2009 is now just around the corner, so with that I would like to share with you one of the new possibilities in the reporting area, Matrix reports. First I will go through how to build a Matrix Report in NAV 2009 SP1, then I will demo…


What is new in Dynamics NAV 2009 SP1 for Reporting

With our Microsoft Dynamics NAV 2009 SP1 Community Technical Preview released it is now time to drill into the new features we have been for working on for reporting in NAV 2009 SP1. 1. Drill Through to a report from a report In NAV 2009 it was possible to Drill Through from a Report to…


Report Design in Microsoft Dynamics NAV 2009

We have now released training material for designing reports in NAV 2009. This training will teach the learners about the concepts of Report Design in NAV 2009 using VS Report Designer along with the limitations and workarounds in Report Design. It covers the new options with practical examples on creating reports in report design, creating…


Filtering out blank fields

Some of you have noticed that the Chart displayed in “Customer Order – Summary” contained a series label called Series 1. Well the reason for that being shown is because we have missed to filter out all customer with have no data in the field: Chart_SalesOrderAmountLCY.Value So how is that actually done? Well let me…


Creating Dashboards in NAV 2009

Hi! I want to share with you also another report using some of the new capabilities in point of creating dashboards in NAV 2009. Based on reporting services and NAV data source it is possible to create dashboards for every department. This offers a perfect extension to the default charts directly in the role center….


Demo Reports

I want to share with you some reports that are using some of the new capabilities that are available for use with RDLC reports in Microsoft Dynamics NAV 2009. We have prepared 4 reports which uses these capabilities: Customer – Order Summary: Use of Conditional Formatting (Table colors) Use of Conditional Formatting (Colors in cells)…