Download Item Dashboard

Hallo zusammen!

Wie versprochen gibt es hier das Update zum Thema  Item Dashboard.

(Ausnahmsweise mal in Englisch, Post wird auch anderswertig verwendet)

 

NAV 2009 SP1 - Item dashboard example

Hi all,

Some of you remember the sales dashboard published some months ago.

Based on this there was an idea to create also an Item Dashboard showing inventory, KPI example and a chart.

Waiting on Service Pack 1 the item dashboard is now ready and shows some new reporting capabilities:

"Drill Through a report"

 

You already know that it is possible to "drill through" a page from a report. The sales dashboard shows this example in navigate to the related task page from the report.

The item dashboard uses the new capability: It is based on 2 reports:

Base Report 1 is Item by location: 

Features:  Matrix control | Conditional Formatting | Drill Through report (with passing filter)

Report 2 Item Dashboard

Features: is called from Report 1 | KPI based on images | inventory based on images

Here are some explanations:

New report properties in SP1

EnableHyperlinks: Must be TRUE for report 1

EnableExternalImages: new property in SP1 using external images (is not used in these reports)

Enable Drill through a report and pass a filter

Similar to "drill through pages" you have to set the navigation properties. In case of navigate to a report you have to use (in this example)

=&quotynamicsNAV:////runreport?Report=70011&Filter=Item.%22No.%22:"+Fields!Item_Ledger_Entry__Item_No__.Value

Ok, all "other stuff" should be clear if you are using reporting services with NAV 2009 before SP1.

If you have any questions just let me know

Download Item Dashboard

Rene