Generating 1 report by merging 2 reports

Hi all ,

I have a issue i have 2 tables

table 1 ( consolidated )

PROFIT PERIODS TRADES RANK 223 1 1 100 333 4 2 98 449 8 3 96 123 7 2 12

PROFIT YEAR PERIODS TRADES RANK 223 2007 1 1 88 333 2008 4 2 34 449 2009 8 3 56 123 2010 7 2 23II

Table 2 ( year by year )

I need to combine these tables then generate report

report goal is to sort the table 1 (rank) in the order of top to bottom so that its corresponding columns gets sorted accordingly . i need to compare table 2

Eg - if rank 100 so that its (profit periods trades ) have a value table 1 so in table 2 have to check the values (profit periods year trades) have the same rank or not

This my issue please help me out

Thank you