Dynamic caption of the column

[jollt]

Hi is there any possibility to have dynamic caption for the column?
I want to develop generic reports for my clients, but they do not have the same vocabulary (ex : Company,Unit, Delegation or Direction are used for the same data)

Thanks,

Jérôme

[Carsten Sørensen]

Hi,

Currently you can't change the content of the captions dynamically in an easy way. You might be able to use alias/par's in the captions but that would be a bit limited...

You could consider to use pivot (column groupings) where the column values would equal the caption. However that requires that you would have to CASE WHEN... in the data-source.

Best regards,
Carsten

[jollt]

I don't think it can work to change the name in the sql statement as DAI use this name to design the reports : if the sql does not returns the same column name, the reports won't work anymore.

Perhaps in a futur version of DAI we will be able to implement in the caption fields a sql statement or something like that to retrieve the column names?

Thanks,

best regards,

Jérôme

[Carsten Sørensen]

Hi Jérôme,

Will consider for future!
You are absolutely right about that the SQL columns in the result-set must be "static"...however what I suggested was to compute the caption and use the pivot functionality to put the caption as a column group (looking like a column caption). I think it might work.

Best regards,
Carsten

[jollt]

hi Cartsen,
I am not familiar with the pivot functionality. Can you show me an exemple or tell me where to find explanations?

Thanks,

best regards,

Jérôme

[Carsten Sørensen]

Pivot is the normal group by Column.

The "captions" shown in the columns are the data values of the column group column.

Best regards
Carsten