web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Create Dynamic columns in Grid or Create Pivot table in Grid

(0) ShareShare
ReportReport
Posted on by 48

Hello Everyone

i have a requirement that make column dynamically based on selected data

let us assume i have a filter multi select for inventlocations and if i select 3 the grid will contain 3 columns if i select 5 the grid will contain 5 columns

how can i reach my requirements i need a code to do that ?

thanks in advance

I have the same question (0)
  • Martin Dráb Profile Picture
    238,782 Most Valuable Professional on at

    What do you want to do it with the data? If it's for reporting purpose, the Matrix control in a report would be the easiest option.

    Which version of AX is it about? You don't have the same options in all versions.

  • OmarAbdlhamed Profile Picture
    48 on at

    Hi Martin,

    its for form Grid control in D365fo

  • Martin Dráb Profile Picture
    238,782 Most Valuable Professional on at

    Moved from Dynamics AX forum.

    A grid is not a very good tool for this task. But if you set an upper limit for the number of columns, like ten, you can create a table with such a number of fields and hide those that you don't need at runtime.

    You'll make your life easier if you follow normal F&O GUI design patterns.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 514 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 390

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans