Create a custom script in report
SummaryModify URL in the report data cell
I've been reading about custom script in the report. I followed through online documentation and able to get the value from the "val" variable ($rows->val).
This script is called with each row passing the row data. The $rows parameter is a nested array, allowing you to return a “table” of data rather than just a row. Initially, the $rows parameter contains only data in the first row of the table ($rows [$i]). Each data cell contains a val variable that holds the value of the data cell. It can also contain a URL variable that contains a link for the data cell.