I see report developers as artists, because they start with blank piece paper, just like an artist. And as an artist only our imagination stops us for what we draw and add to this piece of paper. If you have worked with our new RDLC reports in NAV 2009 you have probably realized the many possibilities and options in Visual Studio. So not to limit the creativity of our report developers but to help report developers, we have decided to apply new Report UX Guidelines to many of our reports in the standard application in our next version.
In this demonstration, you’ll learn about several new Reporting features available in Microsoft Dynamics NAV 2009. These include Layout and Display features as well the new Navigation functionality.
In this demonstration, you’ll learn about several new Reporting features available in Microsoft Dynamics NAV 2009. These include Layout and Display features as well the new Navigation functionality.
In this demonstration, you’ll learn about several new Reporting features available in Microsoft Dynamics NAV 2009. These include Layout and Display features as well the new Navigation functionality.
In Part 1 we created a table and a processing report in Dynamics NAV that would enable us to later access every Dynamics NAV option string value in a SQL Reporting Services report. Now, I will show how I handled the query to get option string values into an SSRS report. This is a little less complex than Part 1.
One downside to using SQL reporting services with Dynamics NAV versus a NAV report or another 3rd party solution such as Jet Reports (jet uses C/FRONT to access option values, flowfields, etc. which gets these values directly from NAV) is that you lose the access to the Option String values and instead are forced to deal with the integer values assigned by NAV to each string value at the SQL level.
In Microsoft Dynamics NAV 2009, the process of creating new reports is divided into three phases:
- Defining the data model on which the report is based.
- Defining grouping and totaling for the report.
- Designing the visual layout of the report.
Vertalen
