But bolting it together yourself with those platforms you would have a programmer or team member(s) to make the move. It's far from automatic. It's not a matter of Joomla/Drupal at all but getting the programmer that can make it happen. Anyone that tells you the platform matters needs more seasoning.

Also you risk analysis paralysis if you fixate on the underlying framework.

Reports are simply that. Reports. Just like before you create them as you see fit. The tools may change a lot but a report functionality is something your programmer may have to code up to get what you want. That is and I didn't write it well is this. Sometimes I get a client that wants all this in a click and drag no-code system. You wait for them to find out that for custom things, coding is normal.