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.
Per the comment:
"You can use report builder (http://technet.microsoft.com/en-us/library/ee706623.aspx) to create the reports. But I think you need quite advanced user to do this. I'm afraid it is not a tool everybody can learn in 30 minutes."
Are there any more user-friendly interfaces/add-ons/third-party packages? The person who would be doing this would be someone who can configure Crystal Reports to a certain extent when it comes to reporting once all the fields and tables are available - there is more technically adept staff however for doiing the initial connection to the databases.
Per the comment:
"You can use report builder (http://technet.microsoft.com/en-us/library/ee706623.aspx) to create the reports. But I think you need quite advanced user to do this. I'm afraid it is not a tool everybody can learn in 30 minutes."
Are there any more user-friendly interfaces/add-ons/third-p