CODEWITHSUNDEEP
dynamics-navnavision
Greatxam Darthart
Greatxam Darthart

Reputation: 188

Navision 5.0 Report Sort TotalFields

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?

Upvotes: 0

Views: 491

Answers (1)

Mak Sim
Mak Sim

Reputation: 2324

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.

Upvotes: 1

Related Questions