Announcements
No record found.
Hi all..
in table LogisticsElectronicAddress, i have data like this :
But, for my report, i want to convert rows into column for fields Type.
Can i do it? and how?
Please help..
Thanks.
*This post is locked for comments
Could you share the expected result sample
on SQL it is with PIVOT, my suggestion is create a view direcly in SQL and add the pivot in it, next read the view back in ax with direct sql
As Dick suggested, you have to do pivot. Below are some useful links.
dynamicserppros.com/creating-pivot-table-forms-and-reports-in-ax
stackoverflow.com/.../pivot-table-in-ax
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
