Multiple Tables Report

I don't know if someone out there has a better idea but I have accomplished this using a combined table. If the 3 tables with my data are Table 1, Table 2, and Table 3 I do the following:

1. Make relationships where One Table 1 has many Combined Table. One Table 2 has many combined table....etc.
2. Make actions (or pipelines) that say, when there a record is added in Table 1, add a record in the Combined Table where [Related Table 1] = Record ID of new record. Now every record from Table 1, 2 and 3 has a linked record in the combined table.
3. Make lookup fields for the fields you want to compare. In your case, value and contract date for example.
4. Make a bunch of formula fields to present the data nicely.
   For example: [Value Formula] =
    If(
     [Related Table 1]>0, [Lookup Value Field from Table 1], 
     [Related Table 2]>0, [Lookup Value Field from Table 2]...etc....)

I have even brough over dates and made a shared calendar, etc.