Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Getting Started with Reporting Services


By:   |   Updated: 2007-10-09   |   Comments (1)   |   Related: > Reporting Services Overview

Problem
SQL Server has a lot of great features and taking the time to find out what these features are and secondly taking the time to understand these new features is often time consuming and usually only done if there is a real pressing problem.  I still run into these challenges and it amazes me that there is always some way to solve the problem with SQL Server.  I think one of the greatest new add-ons to SQL Server is Reporting Services, but it still seems like a lot of people have not yet adopted Reporting Services.  Microsoft even included Reporting Services features with SQL Server 2005 Express, so this is definitely something you should take the time to investigate. The big question though is how to get started.

Solution
As mentioned already, I think Reporting Services is one of the most useful additions to SQL Server and everyone should be using it to some degree.  The ease of developing and deploying reports is amazing as well as the functionality that you get directly out of the box.  There are always some features that you wish you had, but this is one tool that has just about everything you need.

Why use Reporting Services?
One of the main things that people always want is to see the data that has been collected in some summarized fashion.  The more data you collect the more reports you need to develop.  The ease of developing and deploying reports with Reporting Services alone should be a big reason to adopt this tool, but another great reason is that you have already paid for it.  Reporting Services is part of the SQL Server license, so you might as well use it.  Also, with SQL Server 2005 Express there are Reporting Services features that you can use at no cost.

In addition to having DBAs or Developers write reports, there are also better features in SQL Server 2005 to push this report development out to your end users, but you still control the what data they see and how tables are joined to ensure some kind of query optimization.

How to use Reporting Services?
Getting started with Reporting Services is really not that difficult.  If you have designed reports in MS Access you can build reports with Reporting Services.  In may be a little overwhelming at first and that is why the best approach to get your feet wet and to start using Reporting Services is to take the time to go through the sample reports and the tutorials that Microsoft put together.

The following is a summary of the tutorials that have been put together.

Creating a Basic Report

For additional tutorials visit these pages:

By going through the lessons you get a chance to use the new Business Intelligence Studio, but also get a quick way of understanding how to navigate through the tool.  

Taking the time to go through the lessons will definitely give you a good sense of how to use Reporting Services, but it won't make you an expert nor will it give you insight into your data and how to setup things, but it will give you a jump start as to what is possible and hopefully will give you some ideas as to how this tool can be a great asset to your company.

Next Steps

  • Take a look at the sample tutorials to get comfortable with Reporting Services
  • Find a business user that has some interest in uncovering information from all the data that is collected and work them to define some reports they could use
  • Start off with a small project or one concept to better understand the potential
  • Take the plunge and use Reporting Services, why not it's free


Last Updated: 2007-10-09


get scripts

next tip button



About the author
MSSQLTips author Greg Robidoux Greg Robidoux is the President of Edgewood Solutions and a co-founder of MSSQLTips.com.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Friday, September 17, 2010 - 4:37:24 PM - Xavier Back To Top
I currently use Crystal Reports XI for all my reporting, i would like to use SSRS as reports will preview faster for the users but i have a dilema i have not been able to overcome.

80% of my reports have dynamic data in the report header in SSRS i have not been able to figure out how to put fields with dynamic data in the report header or footer.

I consider myself a proficient Access and Crystal developer but this has me stumped.

Am I missing something here?, or i have not been able to figure it out because SSRS does not support dynamic fields in the header or footer.

Thank you

Xavier


Learn more about SQL Server tools