I Microsoft Access you can create Pivot SQL statements like this:
"TRANSFORM Sum(LEDGERTRANS.AMOUNTMST) AS SumOfAMOUNTMST
SELECT LEDGERTABLE.ACCOUNTNUM, LEDGERTABLE.ACCOUNTNAME
FROM LEDGERTRANS RIGHT JOIN LEDGERTABLE ON LEDGERTRANS.ACCOUNTNUM = LEDGERTABLE.ACCOUNTNUM
WHERE (((LEDGERTRANS.TRANSDATE) Between #1/1/2003# And #12/31/2003#))
GROUP BY LEDGERTABLE.ACCOUNTNUM, LEDGERTABLE.ACCOUNTNAME, PIVOT AX_CT_DRIFT_LEDGERTRANS.DIMENSION;"
How can I do the same data set in Axapta and use it in a report?
Best regards, Tom Bak
Yahoo! Groups Sponsor ADVERTISEMENT
Click Here!
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
