Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Group/Merge Columns in List Form's Grid

(0) ShareShare
ReportReport
Posted on by 44

Hi all,

Is it possible in a grid to group Columns or display like a Title group of columns. Something like the image below.

The Idea is to display all started productions and Compare: the Qty made vs Qty estimated , Time(hours) Made vs Estimated by production operations

here a Layout example:

pastedimage1622447838413v1.png

Probably the operations columns has to be made by code. since each company has different operations.

any other idea and/or possible workaround would be greatly appreciated.

thanks a lot beforehand!

  • Suggested answer
    CBNestor Profile Picture
    44 on at
    RE: Group/Merge Columns in List Form's Grid

    Hi Nikolaos,

    Actually that was the best solution so far. Thanks for the Idea!.

    pastedimage1624011239119v1.png

    more details Workaround for subqueries for a Form ListPage AX2012

  • Suggested answer
    Hossein.K Profile Picture
    6,646 on at
    RE: Group/Merge Columns in List Form's Grid

    Hi Nestor,

    There is no feature to do this in grid in AX, but with a bit creativity, you can support it in other way.

    For example put a second grid above of your grid and  configure the columns like you want.

  • CBNestor Profile Picture
    44 on at
    RE: Group/Merge Columns in List Form's Grid AX2012

    Hi Nikolaos,

    Probably I did not explained myself so well. How Can I link them in a way the each row will be releated to the row of the prodId.

    More specifically I have this example:

    I change a little bit the logic. Instead of getting all the OprId fixed, I will group maximun 10 operation Numbers (10 groups), so group column 1 will be OprNum 10, Column2 = OprNum 20, 30...till OprNum 100.

    How do I make the Query in order to link each ProdRoute Datasource with the main ProdTable Datasource? 

    5148.pastedimage1622648909437v1.png

    I think Is the first time I try to do something like this in dynamics

    I am using a FormListPage by the way.

    I really appreciate you help.

    thanks a lot!

    later I can think of grouping the column by color as you suggested, I don't know if its possible.

  • CBNestor Profile Picture
    44 on at
    RE: Group/Merge Columns in List Form's Grid AX2012

    Hi Nikolaos,

    Probably I did not explained myself so well. How Can I link them in a way the each row will be releated to the row of the prodId.

    More specifically I have this example:

    I change a little bit the logic. Instead of getting all the OprId fixed, I will group maximun 10 operation Numbers (10 groups), so group column 1 will be OprNum 10, Column2 = OprNum 20, 30...till OprNum 100.

    How do I make the Query in order to link each ProdRoute Datasource with the main ProdTable Datasource? 

    pastedimage1622648909437v1.png

    I think Is the first time I try to do something like this in dynamics

    I am using a FormListPage by the way.

    I really appreciate you help.

    thanks a lot!

    later I can think of grouping the column by color as you suggested, I don't know if its possible.

  • Verified answer
    nmaenpaa Profile Picture
    101,156 Moderator on at
    RE: Group/Merge Columns in List Form's Grid AX2012

    As I mentioned, you could use color coding to distinguish the groups on a single grid.

  • CBNestor Profile Picture
    44 on at
    RE: Group/Merge Columns in List Form's Grid AX2012

    Hi Nikolaos,

    thanks again for fast reply,

    I understand what you mean, but I am not clear about the right approach.

    I want it to have the look of a listpage like ProdTableListPage. You are saying that I could separate the Operations(Groups) on each grid. that means 20 opr. = 20 Grids total.

    Now I have the doubt about the ordering and filtering and scrolling. If I make it per separate grid. then how can I make sure that the row I am seeing on one grid corresponds to the same row  (production) of the other grids?? wouldn't it be like a disaster?

    by the way is it possible to use the listPage design with many grids.

  • Suggested answer
    nmaenpaa Profile Picture
    101,156 Moderator on at
    RE: Group/Merge Columns in List Form's Grid AX2012

    Hi Nestor C,

    it's not possible to add some "group titles" on top of the column titles of a grid.

    But since you anyway have to create the grid dynamically, you could as well add some visual indicator about the groupings. Such as different background color for grid fields of different groups.

    Or put each group of fields in separate grids.

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.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,001 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans