Nagesh, This change deals with the AX 4.0 Datasource property ordermode. In AX 4.0 this property could be set to Order by (default) or Group by but in AX 2009 two new nodes appears in our query object: Order by and Group by. There are certain things i observed. Queries built in AX 4.0 and upgraded to AX 2009 will continue working the old way Building a new query in AX 2009 will always work the new way because the property order mode is not available anymore The report wizard in AX2009 still makes a data source query with the order mode property on the data source. (seems to be an issue, bug ) Santosh
--- On Wed, 23/12/09, Nagesh <nageshsi...@yahoo.com> wrote: From: Nagesh <nageshsi...@yahoo.com> Subject: [Axapta-Knowledge-Village] AX 2009 Report datasource ordermode property - Urgent To: Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, 23 December, 2009, 1:08 AM Hi All, I m facing an starnage problem while creating report. I created a new report in AX 2009 and added a salesTable in its query datasource. Now I open the properties woindow of the query datasource. There I can't see the OrderMode property. Also the Sorting node under the datasource is not available in this case. But these things are there in all of the standard reports. Can you please tell me how I can get these things in my reports also. Its an urgent. Thanks in advance, Nagesh The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/