Getting links to documents in a project level report

[TimothyBr]

Hey there! 

Does anyone know any text mode to get links to documents inside of a project level report? 

Even better, if you can put logic in to look at folders based on name? 

Thanks! 

[ninoskuflic]

What are you trying to achieve? Show a report of all projects in e.g. a program/portfolio and show all documents (links) that are within that project? Like a full list (links) of documents? 

[TimothyBr]

I am trying to see a subset of projects for a group (so could span multiple portfolios), and then the documents within each of those projects. For this example, we have certain projects that fit a criteria (custom fields), and we have deliverables in folders with the work Final in it. I have the text mode to only pull in assets in those folders I just cannot get the links in the report. 

I have my fusion expert working on a fusion scenario for this, but wanted to see if there was something out of box. 

[ninoskuflic]

If the text mode is already pulling document ID's for example, you can try to use CONCAT to create the link manually - that should work and the link should be clickable in the report? Can you share the text mode so that we can take a look?