I have a requirement to develop SSRS Report from Sharepoint 2010 list.
Here I need to pull the data from 2 lists . Since there is a storage issue with the lists,we have moved the items from list 1 to list 2 on specific days.
List 1 will have records(items) 1-10
List 2 will have records(items) 11-20
List1 and List 2 have same structure.
I need to show the records from list 1 and list2 that is records 1-20 in the SSRS Report.
How can we achieve this task?
Please find attached screenshot of the requirement