create reports by using two sharepoint lists

Actual sample data is ,

i have two lists which contains data after migration data in one list and newer added data in another list,

like the above table , i have two lists and i need to show report as mentioned data as visuals in a single report

thanks in advance /\

hello jaipal,

i am giving you  brief,

Infact, i have two list which contains same columns , the specified columns contains agreement year and agreement type.in that both list , column agremment type is a choice column contains same values and year column contains different time period like 2010 2011 2012 2013 . ( list A having set of year values and list B having set of different year values)

 in this i need to pick values from agreement type agreement year from both list and make reports in number of agreement type in both lists by year.

I dont know how to get both list values integerate with single report.

Hope i am giving you brief ...