Hi,
i have all my images in different server with the number customer ID.
DEV/100 - in dev
QA/100 - in QA
my requirement is if I click on customer ID from my report, it should open that particular customer ID image From the different server location.
I am trying to use HTML data format on the Customer ID column Some thing like below.
<a "dev"||Cust ID column>CUST ID column</a>
but my issue is when I move report from dev to QA, it is still pointing to Dev because Dev is hard coded.I am trying to variabilize this. But variables are not working inside <a>.
can anyone tell me how can I a hive this or if you think any other way is good for this. Please advise me?