Change Text-Label Column (Cross-Tab)

[Steff23]

Hi,

i'm looking for a solution on how to change the column names in a cross-table. The existing column names correspond to a database entry.
How can I change the label of this using an if statement? For example: if wage type 4971 appears as a column, the label should be changed to 4971 ('meinText')

Thanks

Steff23

[Lech Kulikowski]

Hello,

As away, you can add the Calculated column with the necessary expression - datasource.column + "your text", and then use it for the Cross-Tab component.

Thank you.

[Steff23]

Hello, but I have the problem that the column name must always be different. In your solution (datasource.column + "your text"), the same text is always displayed. Each column must necessarily have a different text on its own.


Thanks

Steff23

[Steff23]

i found this: {IIF (EMPLOYEEWAGEACCOUNTVALUES.WAGEACCOUNT_NAME == "LA 4971", "MeinText \n@4971", EMPLOYEEWAGEACCOUNTVALUES.WAGEACCOUNT_NAME)}

but i need this for more VALUES like this LA 4972, LA 4973 and more .....

[Lech Kulikowski]

Hello,

You can use the Switch function.

Thank you.