Ask HN: What Is a Good Microsoft Reporting Service Alternate 12 years ago
I had this exact same problem a while back so I made this extremely simple reporting tool [1]. Basically you just give it one or more SQL queries and it displays them as tables on a new webpage. (You can also add charts and things through javascript.)
It may be too simple for what you need, but it works great for me.