Hi Vishal, It not possible for user to sort base on the display fields in reports or forms. But you can try to make a view then use view as datasource in your reports.
Hope this help. Thanks. Khue ----- Original Message ---- From: Agus Riyadi <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, May 24, 2007 3:14:23 PM Subject: Re: [Axapta-Knowledge-Village] Sorting Hi Vishal, You can use CustTable as the second datasource of your query joined to the first one. Then use this CustTable data source for sorting. Regards, Agus On 5/24/07, V G <learnaxapta@ gmail.com> wrote: > > Hi > I have a requirement where in I have to sort the report by the customer > name. The table that is used in the query have customer No but not > customer > name. I am fetching the customer name from the custTable based on > custAccount. > I can create a temp table and insert the record with the customer name and > than fetch it sort by customer name > Is there a easier way or any other way to do this. > Thanks > Vishal > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] ____________________________________________________________________________________Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase.yahoo.com/ [Non-text portions of this message have been removed]