Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 show you:
1. Design Report 70000
2. Select “View / Layout”
3. Right click the chart in the bottom of the report
4. Select “Filters” tab
5. Type the follow:
Expression:
=System.String.IsNullOrEmpty(Fields!Chart_SalesOrderAmountLCY.Value)Operator:
=Value:
=False
6. With this filter we now filter out where "Chart_SalesOrderAmountLCY.Value” is equal blank.
7. Now save and compile the report and display in RoleTailored client. Now only customers with outstanding orders are shown in the chart.
I have updated the demo reports package to reflect this change.
The reports can be downloaded from here.
Thanks,
Claus Lundstrøm, Program Manager, Microsoft Dynamics NAV