I want to create a SSRS report of the item sitting inside a SharePoint document library. Inside my SharePoint document library, we have multiple folders where the document is saved.

When I run SSRS report on that table, it completely ignores items inside folders. How can I get all items in document library without folders limitations?

Thank you


The only solution that worked for me is

  • Modifying the default view of the document library and set the Folders > Folders as Flat: Show all items without folders.

enter image description here

By the way, I tried to edit the Query as a text and set <ViewAttributes Scope="RecursiveAll" /> despite there is no syntax error but the query behavior is not changed. it still shows the folders without its file, so I perform the above solution the worked for me.

For the detail steps, check my article at Show SharePoint Document Library Files With Folders and Subfolders in SSRS


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.