Avatar of Line One
Line One
 asked on

SQL Server Reporting Services - abilities

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.
SSRSDB Reporting Tools

Avatar of undefined
Last Comment
Line One

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Alpesh Patel

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Nico Bontenbal

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Line One

ASKER
Thanks for all the info.

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.
SOLUTION
Nico Bontenbal

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Line One

ASKER
Fantastic. I will take a spin.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23