Hi,

I have a problem with creating a report I need.
I have a table with orders and an object id, and
want to get a list of "Top 100" orders. In standard
SQL I would do something like this

select ObjectId,count(Recid) as number
      from orders
      group by ObjectId
         order by number

However I cannot find way to build a report query
to do this, as the "Ordermode" is per table and not
per field.

Is there a way to do this in Axapta without doing
lengthy coding?

Stefan     





Yahoo! Groups Links

Reply via email to