If you are on Sage 100 Premium (SQL); you could develop a SQL View that includes data from both, and then use that View in a Crystal Report.  If not, the best you can do is to write a sub report for live data and have what is essentially two reports on one report.  

Thanks for the reply.  Unfortunately we are not using Sage 100 Premium (SQL).  If I used the sub-report approach, would I be able to combine the totals from both reports into one grand total?

Thanks for the reply.  Unfortunately we are not using Sage 100 Premium (SQL).  If I used the sub-report approach, would I be able to combine the totals from both reports into one grand total?

If you use variables in the sub report, you can then carry the value into the main report and use it in calculations.  

I've never created a sub-report before. Any thoughts on the best place to find a tutorial or examples?