Change header depending on a specific parameter

Or Fried shared this idea ago

Idea Logged

I want to show the same column with the same calculation. But I want the header name to be changed by a specific flag of the client organization.

For example, if the client organization is a retail customer his discount called ‘C.Client Reduction’. And if the client organization is Wholesale customer, the same calculation is called ‘Agent Commission’.

If I had an option to change the header(the best option) or to have two columns with different header and decide when to show or hide the column this will solve the problem.

If there will be an option to add something like that it will be great.

An example from my reporting tool (a column header):

f877817091a759f17fe12210694b902d

This is what retail/wholesale parameter :

select value as ID

from ConfigurationData

where [key] = 'wholesale'

and section='General'

and ConfigurationId=0