Filtering out blank fields


Some of you have noticed that the Chart displayed in “Customer Order - Summary” contained a series label called Series 1.

clip_image002

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

image

4. Select “Filters” tab

5. Type the follow:

Expression:
=System.String.IsNullOrEmpty(Fields!Chart_SalesOrderAmountLCY.Value)

Operator:
=

Value:
=False

image

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.

image

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

Comments (0)

Skip to main content