Navision 5.0 Report Sort TotalFields

Question

I'm new to MS Dynamics NAV 5.0, I have created new Purchase Inventory Line Report using Report Designer. I have also group the line per item and total the quantity and the amount. What I trying to achieve is to sort the amount descending order.

This are my settings for the report.

DataItem: Purch. Inv Line

Properties:

GroupTotalFields = No.

TotalFields = Quantity, Amount

Sections:

Purch. Inv. Line, Header

Purch. Inv. Line, GroupFooter

Now how do I sort the TotalField: Amount by descending order?

Can you give a little more info regarding the data-items you have used so far? It's possible to sort a data item based on the keys that are available in the table. Or you can use a temp table like in report 111. — gbierkens
Hi I have read the report 111 Customer Top 10 List. The report insert record to the Customer Amount table, but I don't know how does the report sorted records by amount descending. Thanks! — Greatxam Darthart

Mak Sim Mak Sim · Accepted Answer · 2015-02-13T17:14:43

You can't sort data by totals using report properties. But you could do this manually. Just iterate through inventory lines and save grouped and totaled results to temporary table variable. Then create new dataitem with base table called "Integer" and use it to print out the results in sections. You can find examples of this trick in many standard reports.

Navision 5.0 Report Sort TotalFields

1 Answers