Launching Attachments from custom report

Has anyone created a custom report to show Attachments?
If so, do they launch when double clicking them?

I have have had a request from a stakeholder where we use Contracts and Master Contracts.
Attachments are only added at Contract level.
However, the request is to show the attachments from the subordinate contracts on the Master Object View.
My SQL report has the ALFA_IDOCUMENT REFSTR as the first column but this does not launch the document.
This class is not available in AQL to test with

Thanks in advance