Creating reports and dashboards | Stimulsoft community forum

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

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.

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

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 .....

Hello,

You can use the Switch function.

Thank you.