I'm use SQL Server as a programmer, but have never gotten much into creating reports on it. I've heard of SQL Server Reporting Services, but am not clear on whether it actually has to run on the same server as the SQL Server instance or not. Also not clear as to how "end user" friendly it is when designing reports.
In the (far) past, I've created custom reports with Access. I'm wondering if setting up Access to connect to a remote SQL Server would a better alternative for a non-programmer user to create and update custom reports.
Any words of advice or pointers would be appreciated!