As far as I know, it takes a macro to open embedded objects by push button. We get rid of this limitation when we open stand-alone documents by means of ordinary hyperlinks. Any office document can have forms attached.
There are no reports outside the Base document except for Calc sheets with linked import ranges. WIth a little bit of hand made column layout, page styles and cell styles Calc can be fine tuned to serve as additional report generator not as good looking as Writer documents but with a lot of extra functionality.
Loading reports and forms filtered by current form content is possible without macros if the filter criteria are stored in some filtering record. Search this forum for "power filtering" by user Arineckaig.
Filtering record sets by macros requires programming skills even when you copied the methods from existing code. The details depend on the exact data types and how to substitute parameters with programatic variables of appropriate types.