Re: [Axapta-Knowledge-Village] Re: Doubt in RecordSortedList
Hi, Thanks for your reply it's very useful to me. I refered the salesRankingReport ,in this report i noticed they used recordsortedlist , and they used sortorder for sorting values, i also use this type of concept but values were displayed in Ascending order only.but i want to display in descemnding order . can u explain the concept about record sorted list? Steeve Gilbert [EMAIL PROTECTED] wrote: Check output menuItem : salesRankingReport. This is report that does just that. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Anjali Kanna [EMAIL PROTECTED] wrote: Hi to all, I have a doubt in RecordSortedList. I want to print the top 50 Customer in customer report.I used one temp table. Using record sorted list values are insertd in to temp table in ascending order,but requirement is to print the top values only .so i need to store the values into the temp table in desc order.I don't know how to do that .if anyone know this concept immediately reply me . it's very urgent Thanks for your help Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/ [Non-text portions of this message have been removed] - Chat on a cool, new interface. No download required. Click here. - Forgot the famous last words? Access your message archive online. Click here. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Doubt in RecordSortedList
Check output menuItem : salesRankingReport. This is report that does just that. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Anjali Kanna [EMAIL PROTECTED] wrote: Hi to all, I have a doubt in RecordSortedList. I want to print the top 50 Customer in customer report.I used one temp table. Using record sorted list values are insertd in to temp table in ascending order,but requirement is to print the top values only .so i need to store the values into the temp table in desc order.I don't know how to do that .if anyone know this concept immediately reply me . it's very urgent Thanks for your help Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/ [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Doubt in RecordSortedList
Hi Anjali, I hope that would help you , please let me know what would happen with you . //Start.. /* The customer with the HIGHEST account number (greater than 100) is found: Pentagon */ CustTable custTable; ; select * from custTable order by accountNum DESC where custTable.accountNum 100; /* To reverse the order from DESC into ASC use reverse */ select reverse custTable order by accountNum; //END.. Best Regards, Khalid Akkawi Dynamics AX Developer --- In Axapta-Knowledge-Village@yahoogroups.com, Anjali Kanna [EMAIL PROTECTED] wrote: Hi to all, I have a doubt in RecordSortedList. I want to print the top 50 Customer in customer report.I used one temp table. Using record sorted list values are insertd in to temp table in ascending order,but requirement is to print the top values only .so i need to store the values into the temp table in desc order.I don't know how to do that .if anyone know this concept immediately reply me . it's very urgent Thanks for your help Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/ [Non-text portions of this message have been removed]