Getting Started with SQL Server Reporting Services 2008

I’ve been working on a new presentation on SQL Server Reporting Services. Over the next few weeks I’ll be creating posts with examples on basic techniques around SSRS. Prior to beginning the posts that will follow, there are a few basic setups you will need to do. Some assumptions are:

· You have SQL Server 2008 Developer Edition SP1 installed on your PC, and are doing the labs there.

· As part of the Developer Edition install, you have installed BIDS (Business Intelligence Development Studio, a series of add-ons for Visual Studio).

· You are familiar with using SQL Server Management Studio.

If you are still on SQL Server 2005, the majority of the techniques demonstrated here will still work. There have been some changes between 2005 and 2008 in the layouts of the BIDS SSRS user interface that you will need to adjust to, many of the screen shots would be different under 2005.

Step 1. Download and install ContosoDW

Contoso is a fictional company created by Microsoft. Similar to AdventureWorks, it provides a repository of retail data. ContosoDW is the Data Warehouse for Contoso, optimized for analysis and reporting. You can download it from:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=868662dc-187a-4a85-b611-b7df7dc909fc

Once downloaded run the installer to create the ContosoDW database in your SQL Server.

Step 2. Create and run the custom scripts for this lab.

There are a series of scripts needed to create the custom views and tables the labs will be reporting from. The easiest way to get them is to download the complete SQL Server Management Studio project along with all the sample labs and other documentation at my Code Gallery site:

http://code.msdn.microsoft.com/getstartedSSRS2008

Step 3. Open BIDS and create a reporting services project.

Open BIDS. (Start, All Programs, Microsoft SQL Server 2008, SQL Server Business Intelligence Development Studio).

Once in BIDS, create a new project. Under project type select “Business Intelligence Projects”, then Report Server Project Wizard”.

Step 4. Setup the shared data source.

To make the transition of reports from development to test to production easier, BIDS allows you to setup a shared data source. The reports can point to this data source, then as the reports migrate among environments all that is needed is to point this shared data source at the appropriate database.

4.1 Right click on the Data Source branch in Solution Explorer and select “Add New Data Source”.

4.2 Click Next to go past the opening screen of the wizard.

4.3 On the next screen you will need to define the connection. Click New, and it will let you fill out a common dialog to create the database connection string. Do so, creating a connection to the ContosoDW database. Once it is in the Data Connections area, highlight it and click Next.

4.4 Give the data source a good name. For this lab I am simply using “Contoso”.

Ready set go!

At this point you should have the basics completed and are ready to start creating reports. Stay tuned to future posts to see a variety of techniques for SSRS.

About these ads

14 Responses to “Getting Started with SQL Server Reporting Services 2008”

  1. Creating a Matrix Report in SQL Server 2008 Reporting Services « Arcane Code Says:

    [...] Getting Started with SQL Server Reporting Services 2008 [...]

  2. Adding Filter Parameters to SQL Server 2008 Reporting Services Reports « Arcane Code Says:

    [...] Getting Started with SQL Server Reporting Services 2008 [...]

  3. Adding Query Parameters to SQL Server 2008 Reporting Services Reports « Arcane Code Says:

    [...] started with this lesson there are some prerequisites you should know about. Please read my post Getting Started with SQL Server 2008 to ensure you have everything setup correctly, otherwise you will be missing objects required to [...]

  4. SQL Server 2008 Reporting Services and the “Select All” Parameter Issue « Arcane Code Says:

    [...] started with this lesson there are some prerequisites you should know about. Please read my post Getting Started with SQL Server 2008 to ensure you have everything setup correctly, otherwise you will be missing objects required to [...]

  5. Interactive Sorting in SQL Server 2008 Reporting Services Reports « Arcane Code Says:

    [...] started with this lesson there are some prerequisites you should know about. Please read my post Getting Started with SQL Server 2008 to ensure you have everything setup correctly, otherwise you will be missing objects required to [...]

  6. Report Headers and Footers « Arcane Code Says:

    [...] started with this lesson there are some prerequisites you should know about. Please read my post Getting Started with SQL Server 2008 to ensure you have everything setup correctly, otherwise you will be missing objects required to [...]

  7. Using Subreports as Areas of Your SQL Server Reporting Services Report « Arcane Code Says:

    [...] started with this lesson there are some prerequisites you should know about. Please read my post Getting Started with SQL Server 2008 to ensure you have everything setup correctly, otherwise you will be missing objects required to [...]

  8. Adding Charts to SQL Server Reporting Services Reports « Arcane Code Says:

    [...] started with this lesson there are some prerequisites you should know about. Please read my post Getting Started with SQL Server 2008 to ensure you have everything setup correctly, otherwise you will be missing objects required to [...]

  9. Linked Subreports in SQL Server 2008 Reporting Services « Arcane Code Says:

    [...] started with this lesson there are some prerequisites you should know about. Please read my post Getting Started with SQL Server 2008 to ensure you have everything setup correctly, otherwise you will be missing objects required to [...]

  10. Jim Says:

    I downloaded the databases Contoso BI Demo Dataset for Retail Industry and tried to restore them. I get the error message about data compression and vardecimal storage are only supported on SQL server enterprise edition. We don’t have enterprise edition. I suspect others are running into the same problem. I was so looking forward to using you tutuorials.

  11. arcanecode Says:

    Jim,

    When I created this series my assumption was folks would be running the SQL Server Developer Edition, which essentially is Enterprise Edition but designed to just run on a local workstation. You might check with your IT department to see if they can install a copy on your machine, or if you are on your own Amazon sells it for less than $50 US.

    Arcane

  12. Sharron Clemons Says:

    [...] Getting Started with SQL Server Reporting Services 2008 [...]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 101 other followers

%d bloggers like this: