SWQL link to node?

yeah, if your report includes the orion.nodes table then add this to your selection nodes.detailsurl as [_linkfor_Caption]

That linkfor function is case sensitive and if you have chosen a different name for the caption field then you need to use the same one on the linkfor

Same sort of method can be used for any table with a detailsurl column, or you can hard code where you want the links to go