Need URL formula link that displays a report from Table #1 while viewing records in Table #2

Yes, absolutely possible.  If you can describe your actual tables and if they are related or how the URL button would know what report  and how to filter the results.  It may also be possible to simply embed a table of results on the Table 2 record using a "Report Link field".