We help IT Professionals succeed at work.

SQL Server Reporting Services - abilities

Line One
Line One asked
on
498 Views
Last Modified: 2012-05-11
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.
Comment
Watch Question

Solution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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.
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Fantastic. I will take a spin.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.