Hello,
I have a table in a report where the text of the header of one column must contain an expression. The problem is that the DataSource of the table is set to the table data. So how can I accomplish this?
Detailed information:
1. The table contains a ranking.
2. The table contains one column with amounts (earnings for the team).
3. The currency of the amounts is set at a higher level (tournament). It depends on the place where the tournament is played.
4. I would like the header to display Prize (EUR) or Prize (USD)
Currently this is done by code, but I would like to know if it's possible to do it with an expression.
Patrick