I am wondering if SQL Server Reporting Services and add-on tools and utiilities can let us create reports from SQL/Access/Excel databases with the following characteristics:
ability to interface with SQL tables/Access/Excel
once the connection/link above is in place, the design of the report should be very graphical and easy to set up assuming the user is familiar with the data fields
once a report is created the ability to distribute a runtime version of it that refreshes itself with new data
I would like someone with field experience in setting up the above - if it can be setup - respond. I am open to alternatives as well other than Crystal Reports.