Dynamic caption of the column

Technical support

Moderators: Bob Cergol, Data Access, Cintac

Dynamic caption of the column

Postby jollt » Mon Jun 27, 2011 8:51 am

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
jollt
 
Posts: 36
Joined: Tue Apr 15, 2008 3:03 pm
Location: Paris - France

Re: Dynamic caption of the column

Postby Carsten Sørensen » Mon Jun 27, 2011 1:15 pm

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
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Re: Dynamic caption of the column

Postby jollt » Tue Jun 28, 2011 7:43 am

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
jollt
 
Posts: 36
Joined: Tue Apr 15, 2008 3:03 pm
Location: Paris - France

Re: Dynamic caption of the column

Postby Carsten Sørensen » Tue Jun 28, 2011 8:02 am

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
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Re: Dynamic caption of the column

Postby jollt » Tue Jun 28, 2011 8:55 am

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
jollt
 
Posts: 36
Joined: Tue Apr 15, 2008 3:03 pm
Location: Paris - France

Re: Dynamic caption of the column

Postby Carsten Sørensen » Tue Jun 28, 2011 9:29 am

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
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen


Return to Technical Support

cron