what is the code function to know the first 10 top

mohmd

iam doig a report named purchase order, its read from purchase line(columnre related to tabel are: vendorno, vendorname, documnetno, no,unit of measure,quantity,outstanding quantity, quantity received, outstandig amount, totla amount, discount %)
in the layout i do the table and line graph(line graph show : vendor no and "quantity,outstanding quantity, quantity received,")
i want when i run the report

i want to show the first top 10 purchaser

Kishorm

You should go through the purchase order lines and buffer the totals to a temporary table - 1 record per purchaser. You then need an Integer DataItem to go through the buffer table and print the result - the Integer DataItem should have the MaxIteration property set to 10 and the buffer table should be sorted by value (Descending).

Marije_Brummel

Hey. Maybe you can use queries like explained in this design pattern

http://community.dynamics.com/nav/w/designpatterns/152.select-distinct-with-queries

With this one

https://markbrummel.wordpress.com/2013/09/10/tip-35-using-queries-in-pages-reports/