Create Dynamic columns in Grid or Create Pivot table in Grid

Like (0) Share

Report

Posted on 3 May 2023 12:22:43 by OmarAbdlhamed

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

All responses (3)

Answers (0)

Martin Dráb 231,723 Most Valuable Professional on 03 May 2023 at 13:31:52

Like (0)

Report

RE: Create Dynamic columns in Grid or Create Pivot table in Grid

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.
OmarAbdlhamed 46 on 03 May 2023 at 13:16:41

Like (0)

Report

RE: Create Dynamic columns in Grid or Create Pivot table in Grid

Hi Martin,

its for form Grid control in D365fo
Martin Dráb 231,723 Most Valuable Professional on 03 May 2023 at 13:07:21

Like (0)

Report

RE: Create Dynamic columns in Grid or Create Pivot table in Grid

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.