Forum Discussion
Is it possible to represent a windows file and folder structure in a report?
I hope the information shared was helpful to you. If your question has been answered, kindly mark the most relevant reply as the Accepted Solution. This small action can make a big difference for others who are looking for the same solution.
Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted If yes, marking the relevant solution would be awesome for others who might run into the same thing.
Thanks for the pointers - I am still stuggling to achieve this. I need it to have the folders at the top then when expanding list the subfolders or files if there are any. Two problems I seem to have when trying every option either given to me by AI or solutions I have found googling.
- Hierachy / relationships: Tried lots of different options, nothing really works.
- Matrix - Always shows the ID and not the folder name / file name - I think its the relationships any ideas?
I am trying to get it like this:
Root
└── Folder1
├── Subfolder1
│ └── FileA
└── Subfolder2
└── FileB
I can manipulate the data easily enough but I have tried single tables / 2 tables with a relationship / 3 tables with a relationship etc etc.
I am using some very basic data as well to try and configure it
| ID | Name | ID_Parent | Type |
| 0 | Root | Folder | |
| 1 | Global Folder | 0 | Folder |
| 2 | 01 Folder | 1 | Folder |
| 3 | 02 Folder | 1 | Folder |
| 6 | 01 Subfolder 1 | 2 | Folder |
| 7 | 01 Subfolder 2 | 2 | Folder |
| 8 | 02 Subfolder 1 | 3 | Folder |
| 100 | Welcome.txt | 6 | Files |
| 101 | Hello.txt | 6 | Files |
| 102 | About.txt | 8 | Files |
| 103 | Config.txt | 8 | Files |
Although my actual live data has 26 levels deep.
Any help would be great