How to create a dynamic report

Hi all,

Looking for your expertise here. I need to create a budget to actual report under the PJC module. I understand both budget and actual numbers can be found under the PMBUDD table but the trick is each contract can varied in length (months). For example, contract A may only span 6 months within a year whereas contract B spans 18 months across multiple years. The question is, how do I create a BI report so that it can dynamically show actual vs budget for each month for the entirety of the contract.

Thank you.