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
Change Text-Label Column (Cross-Tab)
Change Text-Label Column (Cross-Tab)
- Attachments
-
- Label_umbennen.JPG (20.86 KiB) Viewed 403 times
-
- Posts: 6417
- Joined: Tue Mar 20, 2018 5:34 am
Re: Change Text-Label Column (Cross-Tab)
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.
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.
Re: Change Text-Label Column (Cross-Tab)
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
Thanks
Steff23
- Attachments
-
- I need an individual text for each generated column
- Text_onlythesame_print.JPG (28.58 KiB) Viewed 281 times
-
- I need an individual text for each generated column
- Text_onlythesame.JPG (61.23 KiB) Viewed 281 times
Re: Change Text-Label Column (Cross-Tab)
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 .....
but i need this for more VALUES like this LA 4972, LA 4973 and more .....
-
- Posts: 6417
- Joined: Tue Mar 20, 2018 5:34 am
Re: Change Text-Label Column (Cross-Tab)
Hello,
You can use the Switch function.
Thank you.
You can use the Switch function.
Thank you.