Hi Anton,
A workaround is creating another table with array column. Create code to populate data to the new table. Using form/report, change the label appearance of each array in the runtime, based on the data that you want to be displayed as column name. If someone have a better workaround, I would like to know too :-) Regards, Agus -----Original Message----- From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sent: 30 Maret 2005 14:13 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: SQL Statement (crosstable / pivot table) Hi Agus, thanks for your reply, but I guess I can't try it 'cause my company didn't buy the 'OLAP' things hahaha.... --- In Axapta-Knowledge-Village@yahoogroups.com, "Agus Riyadi" <[EMAIL PROTECTED]> wrote: > Hi Anton, > > You can use Axapta OLAP for that purpose. > This requires MS Analysis Services SP3 installed. > > Regards, > > Agus > > > -----Original Message----- > From: Anton Tjiptadi [mailto:[EMAIL PROTECTED] > Sent: 30 Maret 2005 9:27 > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot > table) > > > > Hi guys, > > I want to create crosstable or pivot table from my data, for ex : > > Branch Item Amount > ------ ----- ------- > Branch1 ItemA 10 > Branch1 ItemB 10 > Branch2 ItemB 10 > > Expected result: > > Item Branch1 Branch2 > ----- ------- -------- > ItemA 10 0 > ItemB 10 10 > > can I do it in Axapta? > > thanks in advance, > > > > > > > > > > > > > > > > Sharing the knowledge on Axapta. > Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/