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.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
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 itID 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
