SQL Server supports many connection methods. I sometimes use Excel and/or Access to connect to the database and perform quick queries.
For more complex reporting, I do nightly extracts to a separate database server so as to not load up the production server - this also might be a option for yourself if your access is limited to the production server.
Have a look here Custom Reports with SQL Reporting Services for some idea's using Reporting Services.
Thank you, interesting tutorial.