Hi All,
I’m working on application which required to display/download 5+ SharePoint lists data at once.
Using SPD & DV Webpart I’ve managed to merge all data and display in one view. However, challenge is that as soon as I raise display limit 30+ SP view start acting crazy and gives me error and performance goes down drastically.
Any suggestion how I can resolve this issue?
Try with CAML Query JOIN and save the value in datatable to gridview and then you can download it easily.
Why don’t you use MS Access to download all the lists at once? You can better connect the data sources and if you create new views and forms then it is much more usable.
You can also choose if you like to link the data sources or just download the data source.
You will find more information about the access option here
