Re: [Axapta-Knowledge-Village] Help me out!
Thanks! Brandon. Will try this for sure On 1/26/07, Brandon George [EMAIL PROTECTED] wrote: I have never tried this before, but you might be able to build a query from a query. So for example: Query1 = Order By DataSet Query2 = Built from Query 1, Group by the DataSet I also thought you could Order and Group By within X++ SQL Statements... thanks, J. Brandon George Senior Technical Architect Sunrise Technologies, Inc. http://www.sunriseconsult.com Cell: 706-412-7726 Office: 336-722-6741 http://www.sunriseconsult.com/ http://www.sunriseconsult.com/ From: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com] On Behalf Of pankaj_dbc Sent: Thursday, January 25, 2007 12:46 AM To: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Help me out! In one of my reports I need to sort one of my field in ascending order, I have already used the group by clause in my select query so it is not allowing me to use the order by clause along with that. Can anybody suggest me anyway to do it. [Non-text portions of this message have been removed] -- Pankaj Kumar Gupta -- Technical Consultant | Microsoft Axapta. ILFS Technologies (9810999669). [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Help me out!
In one of my reports I need to sort one of my field in ascending order, I have already used the group by clause in my select query so it is not allowing me to use the order by clause along with that. Can anybody suggest me anyway to do it.
RE: [Axapta-Knowledge-Village] Help me out!
I have never tried this before, but you might be able to build a query from a query. So for example: Query1 = Order By DataSet Query2 = Built from Query 1, Group by the DataSet I also thought you could Order and Group By within X++ SQL Statements... thanks, J. Brandon George Senior Technical Architect Sunrise Technologies, Inc. http://www.sunriseconsult.com Cell: 706-412-7726 Office: 336-722-6741 http://www.sunriseconsult.com/ http://www.sunriseconsult.com/ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pankaj_dbc Sent: Thursday, January 25, 2007 12:46 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Help me out! In one of my reports I need to sort one of my field in ascending order, I have already used the group by clause in my select query so it is not allowing me to use the order by clause along with that. Can anybody suggest me anyway to do it. [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Help me out!
hi pankaj_dbc, please post your code so that you will be helped -subbu Brandon George [EMAIL PROTECTED] wrote: I have never tried this before, but you might be able to build a query from a query. So for example: Query1 = Order By DataSet Query2 = Built from Query 1, Group by the DataSet I also thought you could Order and Group By within X++ SQL Statements... thanks, J. Brandon George Senior Technical Architect Sunrise Technologies, Inc. http://www.sunriseconsult.com Cell: 706-412-7726 Office: 336-722-6741 http://www.sunriseconsult.com/ http://www.sunriseconsult.com/ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pankaj_dbc Sent: Thursday, January 25, 2007 12:46 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Help me out! In one of my reports I need to sort one of my field in ascending order, I have already used the group by clause in my select query so it is not allowing me to use the order by clause along with that. Can anybody suggest me anyway to do it. [Non-text portions of this message have been removed] - Everyone is raving about the all-new Yahoo! Mail beta. [Non-text portions of this message have been removed]