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 ItemAmount
-- - ---
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/
