I believe the use of a temp table can solve this. Regards, Varden Morris
276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] ----- Original Message ---- From: prasad pendyala <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, September 21, 2007 11:50:33 PM Subject: [Axapta-Knowledge-Village] Regarding Reports Hi I want to print data Verticallay in my report like 2004 2005 2006 ------------ --------- --------- --------- --------- --------- - TotalSales 10000 10000 100000 Amount 32000 00000 500000 XXY 120000 1200000 1300000 ------------ ------- ------------ ---- ------------ --- TOT 162000 1210000 1900000 ------------ ------ ------------ --- ------------ ----- I need to pick the values for year wise from COA in Ax 4.0 Can anyone help me in this regard Thanks Prasad.Pendyala ------------ --------- --------- --- Chat on a cool, new interface. No download required. Click here. [Non-text portions of this message have been removed] ____________________________________________________________________________________ Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC [Non-text portions of this message have been removed]