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.com<Axapta-Knowledge-Village%40yahoogroups.com> > [mailto:Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com>] > On Behalf Of > pankaj_dbc > Sent: Thursday, January 25, 2007 12:46 AM > To: > Axapta-Knowledge-Village@yahoogroups.com<Axapta-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. IL&FS Technologies (9810999669). [Non-text portions of this message have been removed]