We are using SP2013 on-premise standard edition. I have several lists with same column structure. All the lists have individual permission which allow different teams submit their report by adding daily records to list.

I need to create a single view for managers. The view will merge all the lists and provide function to sorting, ordering and filtering.

May I know how to do this without too many coding?

P.S. I have tried create a joined data source with SPD2013 and display the view on a blank (no styling at all) aspx. The data are listed correctly but I cannot do any sort, order and filter. Any good reference is welcome. Thank you!

1 Answer 1


It might be help full and well explained


  • Thanks. I have checked this page before. But it only explain what SPDataQuery did. I still not sure how to create a page, show a view bind with the merged datasource.
    – Mark L
    Apr 24, 2015 at 8:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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