Application Express 5.0.4.00.12
Universal theme
I searched old discussions, but wanted to know if there is a better way of getting this done in Apex 5.
I have a requirement to show the filename (as downloadable link) in a report not as a separate column but as hyperlink along with some other text in an existing column.
For example, there is a table called DETAILS with a text column COL1 and there is a table ATTACHMENTS with a file test.txt .
I want to concatenate the link to test.txt as a download link in COL1 which has other text data.
The files are uploaded to a custom table whose columns are as shown below.

Please suggest an easy way to do this instead of creating a separate report.