We have a list with folder structure and has 7900 items in total as of now. We are using
XML data source type for using the List web Service for SSRS reports.
It worked fine till the number of items in the list were<5000. Since the data crossed 5000, it is not working as expected and i get soap exception for the threshold of 5000 items when i put a row limit greater than 5000 in my query parameters, but for
5000 as row limit it generates fine.
I need to display more than 5000 items in my reports.
Please suggest, if we can have a workaround for this with the list web service method or i need to go for "Microsoft SharePoint List" type approach and achieve my requirement (this approach
wasn't working for me where i have list with folders, but i have seen that it doesnt enforce the threshold issue though)?