Document Folders on Report

[KatyRe]

Hi, Is it possible to group or add a field on a documents report showing the folder each document is located in on a project? Thanks, Katy Katy Reid Menzies Distribution Ltd

[pco88]

You can show the folders on a document report by text mode.

displayname=Folder

listdelimeter=<br>

listmethod=nested(folders).lists

textmode=true

type=iterate

valueexpression={name}

valueformat=HTML

Optionally, you can also show the parent folders name in the column.

displayname=Folder

listdelimeter=<br>

listmethod=nested(folders).lists

textmode=true

type=iterate

valueexpression=CONCAT({parent}.{name}," / ",{name})

valueformat=HTML

[stuartcairns]

This is really useful. Is there a way to allow sorting by the folder column in the report? I've added the 'querysort=' parameter but I'm struggling to get the syntax right. Thanks v much.